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