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