Re: How to optimize server for cartesian join?
Date: Tue, 12 Feb 2008 21:26:41 GMT
In article <Kneoj.40$Ll.3_at_read4.inet.fi>, "Jack" <none_at_INVALIDmail.com> 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