RE: Oracle CBO question

That is absolutely correct (about SQL Server). At least in regards to 6.5 version, never worked with 7.0 (or above) - so, don't know.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alberto Dell'Era Sent: Thursday, June 07, 2007 3:09 PM
To: oracle-l_at_freelists.org
Subject: Re: Oracle CBO question

I've plugged ' oracle "16 table join" ' in google and I've found that until 7.0, *SqlServer* used to have this 16 tables limitation.

Curious :)

On 6/7/07, Alberto Dell'Era <alberto.dellera_at_gmail.com> wrote:
> On 6/7/07, Jared Still <jkstill_at_gmail.com> wrote:
> (snip)
> > Why the number 16 was chosen I am not sure.
> > Perhaps someone speculated there was a 4 bit limitation?
> (snip)
>
> It's not the first time I hear about this "16" myth, it would be nice,

> for historical reasons, to know about the source.

--
Alberto Dell'Era
"dulce bellum inexpertis"
--
http://www.freelists.org/webpage/oracle-l



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