Updating information on a very large table
- From: stooky <stooky@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 Apr 2005 09:55:04 -0700
We have a table with 120 million rows and roughly 300 fields. We update the
phone status of these fields every quarter. The phone update is a file of 90
million phone numbers. Basically, any phone number that matches a record in
our 120mil table triggers a record update (a single char field is changed
from 'N' to 'Y').
Any suggestions on how to speed up this process? Right now the update is
taking over 48hrs.
thanks.
.
- Follow-Ups:
- Re: Updating information on a very large table
- From: Shawn Meyer
- Re: Updating information on a very large table
- Prev by Date: Merge Large Tables
- Next by Date: Re: Updating information on a very large table
- Previous by thread: Merge Large Tables
- Next by thread: Re: Updating information on a very large table
- Index(es):