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: Oracle Developer <robert.hill_at_usld.com>
Date: 1997/04/01
Message-ID: <334174db.6533607@news.perftech.com>#1/1

On Tue, 01 Apr 1997 10:08:40 -0500, amit srivastava <amit_at_intrex.net> 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

You can also try a to_char(<column name>) or some sort of translation to the index field in question. Received on Tue Apr 01 1997 - 00:00:00 CST

Original text of this message

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