HINTS in sub queries
can i have hints in sub queries as well.
Will that make any difference in performance.
i have a query like this
select /*+ driving_site(ABC) full(DEF) */
from( select col......
( select col.... from tab3 @dlik2),
can i have hints in the sub queries as well to increase the performance.
Yes, you can hint at the subquery level. It will make your query run ...
- slower, or
- the same
... depending on the query, the data, and the hint.
thanks for the reply.
will try with hints.
Last edited by r_adusumilli; 03-03-2005 at 01:07 PM.
Slimdave has already given you the answer - maybe yes, maybe no.
Originally posted by r_adusumilli
please tell me if hints in subqueries helps here.
Why don't you just try it and look at the explain plan?
Click Here to Expand Forum to Full Width