Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Large table merge
Hi Christina,
can you show a description of your tables? If there are unique constraints in place or if they are deductible then you may work with updatable subqueries.
Martin
sviba wrote:
>
> All,
> I have two large table A:120K record, B: 40K record, try to get the B's 2
> field info into A.
> A and B has 4 common field, those 4 field in B no null values, in A 2 of the
> fileds has null values.
>
> I use join A and B, but it takes me many hours, how should I do to gain the
> speed, I saw sombody do the same thing only take 7 minutes.
>
> Thanks,
> Christina
Received on Tue Dec 18 2001 - 06:38:15 CST