Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Sort Behavior in 8i and 9i

Sort Behavior in 8i and 9i

From: Jamie Pearson <jpearson_at_nspr.com>
Date: Tue, 25 Mar 2003 11:06:17 -0500
Message-ID: <b5pupq$jkj$1@slb6.atl.mindspring.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US