OraFAQ Forum: Performance Tuning » Nested loops, Hash join and Sort Merge joins

Home » RDBMS Server » Performance Tuning » Nested loops, Hash join and Sort Merge joins – difference?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Nested loops, Hash join and Sort Merge joins – difference? [message #222484]

Mon, 05 March 2007 02:29

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

Report message to a moderator

Re: Nested loops, Hash join and Sort Merge joins – difference? [message #222536 is a reply to message #222484]

Mon, 05 March 2007 05:39

Mahesh Rajendran
Messages: 10708
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 30 05:13:19 CST 2024