Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: USING INDEXES
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