Re: Tablespace growing at enormous rate

From: Martin Drautzburg <martin.drautzburg_at_web.de>
Date: 29 May 2002 00:29:06 +0200
Message-ID: <87r8jv29fx.fsf@web.de>

"Joe" <Joe_at_foo.com> writes:

> WHERE
> T.ID = U.ID AND
> T.A = U.A
>
> Every row in U has 10 matching rows in T, so in theory
> the join above should produce 6000 * 10 = 60,000 rows
> only, but instead the join above produces millions (!) of
> rows being inserted into T_TEMP.

Maybe for some reason you got bad (duplicated) IDs and As. We had a similar problem, when one ID suddenly appeared 10,000 times instead of 4 times. Then these joins explode. Received on Tue May 28 2002 - 17:29:06 CDT