Re: Pb with MERGE JOIN (CARTESIAN)

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

">
> I cant read your plan. its too messy. Are you stating that after you
> got the cartesian join your performance improved?
>
> oracle will occassionally use them to improve performance. If you have
> a 3 table join. 2 tables dont have alot of data and the third has alot
> of data. Oracle will ocassionally cartesian join the two small tables
> and use it as a hash map to join to the larger table.
>
> I cant be more specific. Ive only run across it a few times.

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 - 05:07:10 CST