Re: Large table merge

On Sat, 24 Nov 2001 22:57:32 -0800, "sviba" <sviba_at_sviba.net> 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.
>

If you look in the documentation, for Parallel DML, you should find examples of updateable join views that will accomplish what you are after very, very quickly. If your version supports them of course. Received on Sat Jan 26 2002 - 16:12:12 CST