Home » SQL & PL/SQL » SQL & PL/SQL » Tree of Joins ......?
Tree of Joins ......? [message #237110] Sat, 12 May 2007 03:26 Go to next message
ravendra_sharma
Messages: 3
Registered: May 2007
Location: Noida
Junior Member

Can you give the Hierarchy or tree structure of joins Plz?
Re: Tree of Joins ......? [message #237114 is a reply to message #237110] Sat, 12 May 2007 04:07 Go to previous messageGo to next message
pablolee
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
This question makes no sense whatsoever. Please read the stick on how to get a quick answer
Re: Tree of Joins ......? [message #237117 is a reply to message #237114] Sat, 12 May 2007 04:47 Go to previous messageGo to next message
ravendra_sharma
Messages: 3
Registered: May 2007
Location: Noida
Junior Member

actually this is sense full question
tree structure means
equi join non equi join
self jin,outer join , Cartesian join ,
and more and more

like this classification of joins
Re: Tree of Joins ......? [message #237119 is a reply to message #237117] Sat, 12 May 2007 05:09 Go to previous messageGo to next message
pablolee
Messages: 2844
Registered: May 2007
Location: Scotland
Senior Member
go to http://tahiti.oracle.com and read the documentation. You could also google for the answer.
Re: Tree of Joins ......? [message #237310 is a reply to message #237119] Mon, 14 May 2007 02:41 Go to previous message
rleishman
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Do you mean an Explain Plan?

Ross Leishman
Previous Topic: create or replace v/s create
Next Topic: help with matrix query
Goto Forum:
  


Current Time: Thu Apr 27 21:54:59 CDT 2017

Total time taken to generate the page: 0.08292 seconds