Re: USING INDEXES

From: Tom Best <Tom.Best_at_bentley.com>
Date: Mon, 15 Nov 1999 09:44:26 -0500
Message-ID: <38301C4A.CD4C919A@bentley.com>

Oracle does not use an index to do an order by. What would it use it for? Indexes help Oracle FIND a row based on a value. You're looking at many rows, and just want them sorted.

Mark Ragan wrote:

> I have a table which contains many fields, one of which is "OrderNo".
>
> This "OrderNo" WILL have duplicate entries.
>
> I have created an index on this field.
>
> When doing a "Select * from Filename ORDER BY OrderNo" Oracle sorts each
> record before outputting.
>
> How can I force Oracle to use the index?
>
> Why doesn't it use this index by default?.
>
> TIA
Received on Mon Nov 15 1999 - 08:44:26 CST