Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Optimizer, Cartesian Product & Extraneous Table

Optimizer, Cartesian Product & Extraneous Table

From: Dr. J. Sylvan Katz <jskatz_at_coombs.anu.edu.au>
Date: Wed, 06 May 1998 09:23:49 +0100
Message-ID: <35501E15.4CCF162E@coombs.anu.edu.au> 





Can someone please explain why a cartesian product is produced if an
extraneous table name is accidently put in the from clause? Can't the
optimizer determine that the table is not being used?



Regards


Sylvan

Received on Wed May 06 1998 - 03:23:49 CDT












Original text of this message













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