|
|
Archives of the TeradataForum
Message Posted: Fri, 17 Jan 2003 @ 17:25:15 GMT
Subj: | | Re: Daily updates to a history table |
|
From: | | Koduri, Harish |
Just create a intermediate temporary table which contains only accounts which have accnt_class changed from account table. Define
accnt_nbr as primary index for this table (i assume you have accnt_nbr as primary index on the account_class table). Then you can update
the account_class table from the temp table based on the accnt_nbr which is primary index on both tables which should perform better than
other options.
Harish
| |