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

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 25 Mar 1999 17:54:06 GMT
Message-ID: <3701781f.20921253@192.86.155.100>

A copy of this was sent to "Steven Wong" <stevew_at_interlog.com> (if that email address didn't require changing) On Thu, 25 Mar 1999 11:41:33 -0500, you wrote:

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

nope, you can join hundreds (wouldn't want to - the optimizer tends to slow down after a while) and 10's of tables is just fine.

>Thanks,
>Steve
>
 

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Mar 25 1999 - 11:54:06 CST