Re: How to optimize server for cartesian join?

From: Doug Miller <>
Date: Tue, 12 Feb 2008 21:26:41 GMT
Message-ID: <laosj.115$>

In article <Kneoj.40$>, "Jack" <> wrote:
>We have business need to do some countings.
>It is using MERGE JOIN [CARTESIAN], it will go fast with 10.000 count, but
>with 200.000 end sum it will take very long time.
>It is using Reports 6i (a bit old;)

The only way to truly "optimize" a Cartesian join is to eliminate it, by creating an index for at least one of the tables, on the column(s) used in the join. Received on Tue Feb 12 2008 - 15:26:41 CST

Original text of this message