Re: oracle create index

Yes,
Oracle does not care what you call your indexes...the name is for your convenience .. If the CBO determines that the index should be used, it will be. Be sure to analyse your tables regularly, especially if large changes are made.

"John" <nihal_at_newmexico.com> wrote:

>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 - 12:43:55 CDT