Hi,

I am selecting some indexes from dba_indexes :
----------------------------------------------
select index_name,degree from dba_indexes where degree <>1;

INDEX_NAME DEGREE
------------------------------ ----------------------------------------
SYS_IL0000000173C00005$$ 0
SYS_IL0000000178C00048$$ 0
SYS_IL0000000230C00026$$ 0
SYS_IL0000000234C00028$$ 0
SYS_IL0000000240C00026$$ 0
SYS_IL0000000245C00026$$ 0
SYS_IL0000000249C00034$$ 0
SYS_IL0000000253C00034$$ 0
SYS_IL0000000264C00008$$ 0
SYS_IL0000000321C00002$$ 0
SYS_IL0000000326C00002$$ 0
SYS_IL0000000331C00002$$ 0
SYS_IL0000000336C00002$$ 0
----------------------------------------------

Just want to know that what does the meaning of degree '0'.

Regards,
Sandeep Saxena

ForwardSourceID:NT000231E2

Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you

Oracle LazyDBA home page