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 -> Re: Pb with MERGE JOIN (CARTESIAN)

Re: Pb with MERGE JOIN (CARTESIAN)

From: zeb <thierry.constant1.nospam_at_free.fr>
Date: Fri, 2 Jan 2004 12:02:10 +0100
Message-ID: <3ff54f1a$0$1180$636a55ce@news.free.fr> 





> Cure problems instead of fight symptoms.

> Merge join cartesian usually means a join predicate is missing.

>




> Cure problems instead of fight symptoms.

> Merge join cartesian usually means a join predicate is missing.

>



Are you sure ?


Why if I decrease sort_area_size


the MERGE JOIN CARTESIAN become a NESTED LOOPS  ?



Thanks
Received on Fri Jan 02 2004 - 05:02:10 CST












Original text of this message













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