Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Sort Behavior in 8i and 9i
Can anyone tell me if Oracle 8i or 9i will utilize a non-unique index when
sorting a result set. Here's an example:
TABLE_A (col1, col2, col3)
Primary key is col1.
Non-unique index on col3.
Statement:
SELECT * FROM TABLE_A ORDER BY col3
DBA says it will, but explain plan indicates a full table scan with no reference to the non-unique index. Granted, explain plan has limited usefulness.
Thanks for the help,
Jamie
Received on Tue Mar 25 2003 - 10:06:17 CST