Re: how to handle updates to millions of rows

lord.of.board_at_gmx.de (Peter Mueller) wrote:
> Unfortunately the merge command is not what I was looking for.
> I just need to find an efficient way to join data from two tables and
> have the original records deleted.
>
> before:
>
> table a (apx. 8.000.000 records)
> table b (apx. 8.000.000 records)
> table a_an_b_joined (0 records)
>
> What I would like to have afterwards:
>
> table a (apx. 1.000.000 records)
> table b (apx. 1.000.000 records)
> table a_an_b_joined (apx. 7.000.000 records + converted currencies)

This seems to be a weird design in the first place.

>
> The procedure has to be run once a month.
> How can I achieve this?

What has been deficient about the (non merge) advice you have already received?

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB