Re: merge join cartesian- access path?

From: Gerard H. Pille <ghp_at_santens.be>
Date: 1997/10/29
Message-ID: <01bce444$adf8bd00$7b1340c0@pcghp.santens.be>#1/1

Difficult to judge without the query itself

-- 
------------
Kind reGards
     \ /   |
      X    |
     / \   x
     Gerard

Tlcbus <tlcbus_at_aol.com> schreef in artikel
<19971029025101.VAA17734_at_ladder02.news.aol.com>...


> To all: In order to improve performance, I created a small temp table

 from


>  original 

> big table to reduce joining operations. In step 4.2 I found merge join

>  cartesian step,

> and my query never finishes. generally, cartesian join is caused by

 missing


>  joining

> columns from 2 tables(This is not the case here). Any clues ?

>

Received on Wed Oct 29 1997 - 00:00:00 CST