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 -> URGENT!! Limit on Number of tables

URGENT!! Limit on Number of tables

From: <rtallak_at_ems.att.com>
Date: Wed, 16 Jun 1999 15:01:26 GMT
Message-ID: <7k8e7v$mf4$1@nnrp1.deja.com> 





Hi All,



Is there a limit on the number of tables that can be joined in Oracle
8i in a SELECT query? I read that there is a 16 table limit on joins is
it true for Oracle 8i? URGENT!!



In general, is there any performance drop when the number of tables
joined is large (like > 10)?



Thanx in advance,.


RTallak




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Wed Jun 16 1999 - 10:01:26 CDT












Original text of this message













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