Archives of the TeradataForum

Message Posted: Fri, 12 Apr 2002 @ 13:35:00 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>