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: 2834
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: 2834
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: 3724
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: Sat Dec 03 19:52:54 CST 2016

Total time taken to generate the page: 0.15865 seconds