The INDEX_DESC hint explicitly chooses an index scan for the desired desk. If your statement uses an index selection scan, then Oracle scans the index entries in descending order in their indexed values. Inside a partitioned index, the results are in descending order within Just about every partition. jfsjfs 353k156156 http://wernerq122ypd1.targetblogs.com/profile