DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: How can i force optimizer to use hash anit join

  1. #11
    Join Date
    Jan 2004
    Posts
    162
    Not sure to be honest. It *might* help to see TKPROF output for this SQL.

  2. #12
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    As far as I have observed, I have had experinces with such SQL going for Hash Aj, where as if put the same code in DML ( like Update and Merge ) it goes for filter.. Sounds like a bug or is that am missing some point..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #13
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    have you tried raising a TAR?

    Once you get past the numpty at 1st line support, might find someone intelligent who could help

  4. #14
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Try it on 10.1.0.3, we had reports of plan wierdness in 10.1.0.2 (I think it was with merge cartesian joins though)
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  5. #15
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    After you create those tables, analyze them, then does your merge consistently explain the same way?
    This is a good one for Tom Kyte (asktom.oracle.com). He's got a big brain.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  6. #16
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by davey23uk
    have you tried raising a TAR?

    Once you get past the numpty at 1st line support, might find someone intelligent who could help
    Will raise a TAR for sure.. but before i do.. i wanted to make sure I didnt miss anything..

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #17
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by KenEwald
    After you create those tables, analyze them, then does your merge consistently explain the same way?
    This is a good one for Tom Kyte (asktom.oracle.com). He's got a big brain.
    All tables are analyzed.. with histograms too..

    BTW, i never get a chnage to post in ASKTOM site .. always see the status as

    Sorry I have a large backlog right now, please ask a question later

    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  8. #18
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by abhaysk
    BTW, i never get a chnage to post in ASKTOM site .. always see the status as

    "Sorry I have a large backlog right now, please ask a question later"


    Abhay.
    If any one gets a chance to post in Tom Site... can you post this one?

    Rgds
    Abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

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