Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace growing at enormous rate
"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