Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Forcing not to use an index in 7.1.6?

Re: Forcing not to use an index in 7.1.6?

From: Chris Andrew <earl_at_bell.us>
Date: 1997/04/02
Message-ID: <3342F1D6.6A2C@bell.us>#1/1

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
 

-- 
Yepp.

Use hint: /*+ FULL*/ in your query.
Received on Wed Apr 02 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US