Archives of the TeradataForum
Message Posted: Fri, 12 Apr 2002 @ 13:35:00 GMT
| Subj: || || Re: Are updates generally slow in Teradata |
| From: || || Satish Umale |
Well, as said & experinced too, updates are very costly on teradata. The turn around would be to use the intermidiate table then use
Insert-Select and drop them when finished.
For example in the senario you mentioned I would create a tables, one insert the records the records to be updated with new values.
Second step insert the remaining records. Third step drop the old table and rename the intermidiate table to old table.
This is much much faster when update is more than 20% of your data in the table.