RE: Oracle CBO question
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <alberto.dellera@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Jun 2007 15:32:19 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alberto Dell'Era
Sent: Thursday, June 07, 2007 3:09 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> wrote:
> On 6/7/07, Jared Still <jkstill@xxxxxxxxx> 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"
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
