-
HINTS in sub queries
Hi,
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) */
col
from( select col......
from tab@dlik),
tab2@dlik,
( select col.... from tab3 @dlik2),
tab4
where
some joins;
can i have hints in the sub queries as well to increase the performance.
please help.
Thanks.
-
Yes, you can hint at the subquery level. It will make your query run ...
- faster,
- slower, or
- the same
... depending on the query, the data, and the hint.
-
thanks for the reply.
will try with hints.
Thank you
Last edited by r_adusumilli; 03-03-2005 at 02:07 PM.
-
Originally posted by r_adusumilli
please tell me if hints in subqueries helps here.
Slimdave has already given you the answer - maybe yes, maybe no.
Why don't you just try it and look at the explain plan?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|