Re: oracle create index

From: Guido Konsolke <Guido.Konsolke_at_triaton.com>
Date: Tue, 22 Jul 2003 09:14:37 +0200
Message-ID: <1058857956.217826@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 - 02:14:37 CDT