Re: limit on number of tables in join

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <ranko.mosic@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 28 Apr 2005 17:13:42 +0100

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


Jonathan Lewis
The Co-operative Oracle Users' FAQ
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.


Other related posts: