Re: Oracle CBO question
- From: "Alberto Dell'Era" <alberto.dellera@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 7 Jun 2007 21:08:30 +0200
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"
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: Oracle CBO question
- From: Igor Neyman
- References:
- Oracle CBO question
- From: Joel.Patterson
- Re: Oracle CBO question
- From: Jared Still
- Re: Oracle CBO question
- From: Alberto Dell'Era
Other related posts:
- » Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » Re: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
- » RE: Oracle CBO question
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.
- RE: Oracle CBO question
- From: Igor Neyman
- Oracle CBO question
- From: Joel.Patterson
- Re: Oracle CBO question
- From: Jared Still
- Re: Oracle CBO question
- From: Alberto Dell'Era