Re: Forcing not to use an index in 7.1.6?

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?
>
> -amit

The best way to force and index not to be used, is to add a function to the column in the where column. Such as:

Select *
from Table
where index_col = 'A';

could become:

Select *
from Table
where Nvl(index_col,'') = 'A';

Hope this helps.

Bob Morrison Received on Wed Apr 02 1997 - 00:00:00 CST