Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    3

    Unanswered: HASH_JOIN and NESTED_LOOPS

    Can someone please point me to a link, or links, that will explain, from the basics, what HASH_JOIN and NESTED_LOOPS are?

    I've taken the Oracle PL/SQL, and am currently taking the Oracle DBA course (both at community colleges using Oracle text and materials), but neither have gone into this, and when I inquire about it, I'm told to go look out on the web.

    But I end up with either sites about hash (the joinT type, not the join), or end up in an ongoing discussion that started assuming everyone knew what that was.

    Thx in advance.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: HASH_JOIN and NESTED_LOOPS

    Try here (Oracle Performance Tuning manual):

    http://technet.oracle.com/docs/produ...mops.htm#51921

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •