Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: [Q] Does Oracle have a 16 table limit for their queries?

Re: [Q] Does Oracle have a 16 table limit for their queries?

From: keith boulton <boulke_at_globalnet.co.uk>
Date: Sat, 27 Mar 1999 15:36:00 GMT
Message-ID: <36fce55b.14935516@195.147.246.90> 





On Thu, 25 Mar 1999 11:41:33 -0500, "Steven Wong"
<stevew_at_interlog.com> wrote:



>Does Oracle have a 16 table limit for their queries?


>





No  I think the limit may be 255. I got bored at 50. There is a 64k
limit on statement size. You are very likely to get a poor access path
and perfomance with large numbers of tables.

Received on Sat Mar 27 1999 - 09:36:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US