Best Way to Update Table?

From: chris (anonymous_at_discussions.microsoft.com)
Date: 04/08/04 

Date: Wed, 7 Apr 2004 23:26:02 -0700

Hello,

I have a large table of data. 120million rows, 250 fields
in each row. The important fields in the table for the
update are phone (phone number) and phone_pander_flag
(flag the is Y or N indicating if the person wants to be
called or not).

The data used to updated this large table is in a second
table that is basically just a bunch of phone numbers.
There are 64million phone numbers in this list.

What I want to do is for every phone number in the update
table (the 64million numbers), I want to check the main
table (the 120million record table) for that phone number
and if there is a match, switch the phone_pander_flag to
a 'Y'.

So far, the fastest I've gotten this to run is 50hrs.
There must be a faster and better way.

Let me know.

Chris.

Relevant Pages