Home » SQL & PL/SQL » SQL & PL/SQL » Join Algorthim (Oracle 9i Linux)
Join Algorthim [message #315097] Sat, 19 April 2008 00:59 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I need help for explain me the three differents king of join in an Oracle environment.

1) NESTED LOOP
2) SORT/MERGE
3) HASH JOIN

Somebody can explain me with a little example, please!

Thanks a lot

Michael
Re: Join Algorthim [message #315103 is a reply to message #315097] Sat, 19 April 2008 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Performance Tuning Guide
Chapter 13 The Query Optimizer
Section 13.6 Understanding Joins

Regards
Michel
Re: Join Algorthim [message #315141 is a reply to message #315103] Sat, 19 April 2008 08:02 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Hey, what about CARTESIAN and CLUSTER?

Ross Leishman
Previous Topic: Oracle Log files
Next Topic: How to replace the view with Previledges
Goto Forum:
  


Current Time: Wed Dec 07 13:01:55 CST 2016

Total time taken to generate the page: 0.09917 seconds