Originally posted by Mr.Hanky
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

Ypu, that's a descendingindexalright.

But what would be the advantage for JDF in using one of these over a regular index?