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_at_crowley.com
x72546
904 727-2546

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Thursday, December 21, 2006 2:20 PM To: Thomas.Mercadante_at_labor.state.ny.us
Cc: wjwagman_at_ucdavis.edu; oracle-l_at_freelists.org Subject: Re: Why isn't Oracle Using My Index  

On 12/21/06, Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us> 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


--
http://www.freelists.org/webpage/oracle-l