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.