Re: oracle create index

I see, I was unaware of this. So tell me if I understand correctly, if I create an index of a field, and name it 'whatever' then I make a query using that original field, Oracle will see there is an index for it and use it automatically???

I am running Oracle 9.2.0.2.

Thanks again.

"Guido Konsolke" <Guido.Konsolke_at_triaton.com> wrote in message news:1058857956.217826_at_news.thyssen.com...
> "John" <nihal_at_newmexico.com> schrieb im Newsbeitrag
> news:bfif80$87m$1_at_reader2.nmix.net...
> > Ouch, I was worried this would be the answer. I have a script
> written that
> > could easily build all the indexes with the table name concatinated
> on the
> > front or something of the like, however what I am trying to avoid is
> > rewriting all the other software that makes queries using these
> index names.
> (snipped)
>
> Hi John,
>
> I presume you use a recent version of Oracle.
> In that the Cost Based Optimizer works really
> good so you seldom need to name indexes to use
> in query hints.
>
> Greetings,
> Guido
>
>
Received on Tue Jul 22 2003 - 10:33:18 CDT