Re: Help !! Hints and Explain Plan

>That could be part of your other problem. If you're trying to
>use hints on a table that isnt' using cost-based, the hint
>won't matter.
>

I assume that if one or more of the tables used in the query are analyzed then oracle by default uses a cost based optimiaztion. Am I wrong on this?

>It would help to see the whole query (or at least the FROM, WHERE,
>and ORDER BY clauses, if any) to see if it should be using that
>index.

It is not just the index I was having problems with, it woudn't use nested loops when I hinted to the server to use it.                             

>=---------------------------------------------------------------------
 ---=
>Joe Nardone |
>joe_at_access.digex.net |
 

-- 
*******************************************
-Rajasekaran Rangarajan 
-Administrative Progamming Services
-Clemson University
-Email: raj_at_cs.clemson.edu