Re: Forcing not to use an index in 7.1.6?

From: Thomas kyte <tkyte_at_us.oracle.com>
Date: 1997/04/01
Message-ID: <334429f1.1585109@newshost>#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

Use HINTS.

For example

select /*+ FULL(emp) */
ename from emp
/

Application developers guide and/or tuning manual will have more information.

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD

http://govt.us.oracle.com/ -- downloadable utilities

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Apr 01 1997 - 00:00:00 CST