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