OraFAQ Forum: SQL & PL/SQL » Join Algorthim

Home » SQL & PL/SQL » SQL & PL/SQL » Join Algorthim (Oracle 9i Linux)

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

Join Algorthim [message #315097]

Sat, 19 April 2008 00:59

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

Report message to a moderator

Re: Join Algorthim [message #315103 is a reply to message #315097]

Sat, 19 April 2008 01:44

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Performance Tuning Guide
Chapter 13 The Query Optimizer
Section 13.6 Understanding Joins

Regards
Michel

Report message to a moderator

Re: Join Algorthim [message #315141 is a reply to message #315103]

Sat, 19 April 2008 08:02

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

Hey, what about CARTESIAN and CLUSTER?

Ross Leishman

Report message to a moderator

Previous Topic:	Oracle Log files
Next Topic:	How to replace the view with Previledges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 00:36:51 CST 2025