DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: HINTS in sub queries

  1. #1
    Join Date
    Sep 2003
    Posts
    15

    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.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Sep 2003
    Posts
    15
    thanks for the reply.

    will try with hints.

    Thank you
    Last edited by r_adusumilli; 03-03-2005 at 02:07 PM.

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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
  •  


Click Here to Expand Forum to Full Width