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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 27 Mar 1999 17:35:07 -0000
Message-ID: <922556428.12046.1.nnrp-04.9e984b29@news.demon.co.uk>

I think that 64K limit got kicked into touch in 7.3.2-ish when the PQO started generating massive rewrites on partition views.

Just imagine the number of join orders the optimiser would have to review on a 256 table join !!

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

keith boulton wrote in message <36fce55b.14935516_at_195.147.246.90>...
>On Thu, 25 Mar 1999 11:41:33 -0500, "Steven Wong"
><stevew_at_interlog.com> wrote:
>
>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 - 11:35:07 CST