Enable true descending order indexes
They are treated as a special case of function-based indexes.
--------------------------------------------------------------------------------
Note:
Oracle sorts columns with the DESC keyword in descending order. Such indexes are treated as function-based indexes. Descending indexes cannot be bitmapped or reverse, and cannot be used in bitmapped optimizations. To get the pre-Oracle 8.1 release DESC behavior, remove the DESC keyword from the CREATE INDEX statement.
--------------------------------------------------------------------------------
http://download-west.oracle.com/docs...ndexes.htm#430
MH
I remember when this place was cool.
Reply With Quote