Re: USING INDEXES

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Mon, 15 Nov 1999 10:09:28 -0500
Message-ID: <80p7o0$lit$1@autumn.news.rcn.net>

Mark Ragan <mark.ragan_at_dial.pipex.com> wrote in message news:80p38e$94p$1_at_lure.pipex.net...
> 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?

By using hints in-built in SELECT statements. See Oracle7(8) Tuning manual for details.

>
> Why doesn't it use this index by default?.

Sometimes it (Oracle optimizer) does. See the same source manual.

>
> TIA
>
>
>
Received on Mon Nov 15 1999 - 09:09:28 CST