To check if an index is a reverse index,
look at property column on ind$ view
0x04 value means reverse index
SQL> select obj#, dataobj#, type#, property from ind$ where ts#=2;
OBJ# DATAOBJ# TYPE# PROPERTY
---------- ---------- ---------- ----------
24051 24051 1 1
24053 24053 1 1
24071 24071 1 4 <--- Reverse index
****************************************
keywords reverse key index
****************************************
No comments:
Post a Comment