Re: Forcing not to use an index in 7.1.6?

You can solve it 2 ways:

• if you use the COST optimizer (I won't, unless I had 7.3), you can use hints. - or you can force the optimizer to ignore the index:

for example, suppose you have a COL1 column indexed (and it is numeric): you do this:

        WHERE COL1 + 0 = 4444
or if COL1 is a CHAR,VARCHAR?,

        WHERE COL1 || '' = 'Hello'

This will work with any optimizer/version of SQL.

If you are tuning SQL commands, I recommend you to go for a look at my company's web site: www.cardume.com and get there a demo for our TunaSQL for ORACLE: DBA Edition product.

Fernando (morgan_at_cardume.com)
CardumeSoftware
www.cardume.com

amit srivastava <amit_at_intrex.net> wrote in article <334124F8.4EEF_at_intrex.net>...
> Is it possible to force Oracle to not to use an index,
> because using a particular index will actually slow down the
> performance for a query?
>
> -amit
>
Received on Tue Apr 01 1997 - 00:00:00 CST