Re: How to optimize server for cartesian join?

From: Doug Miller <spambait_at_milmac.com>
Date: Tue, 12 Feb 2008 21:26:41 GMT
Message-ID: <laosj.115$Mw.13@nlpi068.nbdc.sbc.com>

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

This message: [ Message body ]
Next message: Charles Hooper: "Re: Primary key question"
Previous message: joel garry: "Re: Do statistics effect the SQL Runtime engine ?"
Maybe in reply to: Steve Howard: "Re: How to optimize server for cartesian join?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message