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_at_gmail.com> To: <oracle-l_at_freelists.org> 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 Received on Thu Apr 28 2005 - 12:19:08 CDT