Home » RDBMS Server » Performance Tuning » Nested loops, Hash join and Sort Merge joins – difference?
Nested loops, Hash join and Sort Merge joins – difference? [message #222484] Mon, 05 March 2007 02:29 Go to next message
oraclearora
Messages: 6
Registered: February 2007
Location: Delhi
Karma: 0
Junior Member
For beginers, this may help.

Nested loops, Hash join and Sort Merge joins – difference?

http://oracle-online-help.blogspot.com/2007/03/nested-loops-hash-join-and-sort-merge.html


Re: Nested loops, Hash join and Sort Merge joins – difference? [message #222536 is a reply to message #222484] Mon, 05 March 2007 05:39 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Karma: 0
Senior Member
Account Moderator
Appreciate your posting.
It would better serve the cause if you would publish these in our blogs/wiki. By posting the link in forum, it will be promptly flushed away in couple of days.

[Updated on: Mon, 05 March 2007 23:53]

Report message to a moderator

Previous Topic: Tuning of a sql querry
Next Topic: when use_hash related hint is used?
Goto Forum:
  


Current Time: Tue Aug 22 12:01:07 CDT 2017

Total time taken to generate the page: 0.05067 seconds