RE: Why isn't Oracle Using My Index

Runstats is great, and is especially geared towards latches, (is query
scalable).    However, you need a database without anyone else on it to
get accurate results.

 

Joel Patterson 
Database Administrator 
joel.patterson@xxxxxxxxxxx 
x72546 
904  727-2546 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Thursday, December 21, 2006 2:20 PM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
Cc: wjwagman@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Why isn't Oracle Using My Index

 

On 12/21/06, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:

        Bill,
        
        When you run the query, how fast is the response?


Just to add a bit to Tom's response:

Why not do a 10046 trace on the query?

Run it both with and without the index hint and 
compare the results.

An excellent method for comparing the 2 would
be to use runstats -  http://asktom.oracle.com/tkyte/runstats.html

HTH

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: