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
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: 10672
Registered: March 2002
Location: oracleDocoVille
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: when use_hash related hint is used?
Next Topic: saving time in query execution
Goto Forum:
  


Current Time: Sat Dec 10 20:49:04 CST 2016

Total time taken to generate the page: 0.08386 seconds