Re: Forcing not to use an index in 7.1.6?

On Wed, 02 Apr 1997 15:55:02 -0800, Chris Andrew <earl_at_bell.us> wrote:

>amit srivastava wrote:
>> 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?
>Yepp.
>
>Use hint: /*+ FULL*/ in your query.

Alternatively, you can do some math on the left hand side of the comparator in the where clause. If you say:

Select * from foo
where name||'' = 'Bar';

Then no indexes will be used. Normally one would want to avoid such things, but it's a very effective way to avoid using a certain index. It's a bit of a hack and the hint is usually better though. 8) Of course, when you want to use an index and you find that you aren't, then you should check for this sort of thing. Received on Sun Apr 06 1997 - 00:00:00 CST