Re: Limitation in Oracle query ?

> In T_SQL, the maximum number of tables is allowed in a query is 256.
> Does anyone knows if there is such a limitation with Oracle and what is
> this maximum for Oracle ?
> Is there a limitation for queries on views ?

There is undoubtedly a limit. But at the same time as I say that I can also say a few other things.

1. I've never bumped into it even in applications such as Oracle Financials which have more than 1300 tables and views.
2. If you are bumping into it you need to find a database architect to help you with your design.
3. Long before you get there your performance will be so abysmal you won't much care.

Daniel A. Morgan Received on Sun Feb 04 2001 - 21:17:17 CST