Identify CLUSTERED INDEX or NON CLUSTERED INDEX
Hi ALL,
I've created table as below..
Create table RND_Ind
*(NNum NUMBER(13) Primary key,*
Eid NUMBER(13));
As Index will be created on NNum Column.
But if I create Index on Eid column as below.
Create INDEX RND_Ind_Eid
on RND_Ind(Eid)
What Type of Index (CLUSTERED INDEX or NON CLUSTERED) will be created on Eid Column?.
Also In which Data Dictionary CLUSTERED INDEX or NON CLUSTERED Column will get?
-
Thanks,
RAJ