Re: limit on number of tables in join

No realistic limit on number of tables.
I once created a 254 table join to test
a theory.

RBO optimisation time was a few hours
CBO optimisation time was a couple of seconds

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005






----- Original Message ----- 
From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Thursday, April 28, 2005 4:51 PM
Subject: limit on number of tables in join


What is it ?=20
Also what is max size of sql query ?=20

Thanks, Ranko.
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: