Sunday, March 2, 2008

Check if an index is a reverse key index

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: