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: Daniel Roy <danielroy10junk_at_hotmail.com>
Date: 2 Jan 2004 07:19:27 -0800
Message-ID: <3722db.0401020719.3c73d085@posting.google.com> 





Could you email me your event 10053 output, and tell me your Oracle
version and optimizer_mode, and I'll try to recreate your scenario and
come up with the proper hint to use. The tables stats would also be
useful. I can be reached at my username, minus the JUNK.



Daniel



> Thanks for your answer,

> whith the JOIN CARTESIAN the performance decrease ( 15min )

> I would  suppress the cartesian ?

> but how ?

Received on Fri Jan 02 2004 - 09:19:27 CST












Original text of this message













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