Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How many tables can be joined?
A copy of this was sent to "P. A. Harrington" <"Philip.A. Harrington"@lmco.com>
(if that email address didn't require changing)
On Wed, 16 Dec 1998 14:33:34 -0500, you wrote:
>In Oracle 7.x, the maximum limit for table joins was 16. Has this
>changed for Oracle 8?
>
>..P
Ummm, wrong database. you are talking about Sybase or MS SQL server with 16 tables.
In oracle7, the limit was the same as in Oracle8 -- no limit.
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Dec 16 1998 - 15:57:58 CST