Archives of the TeradataForum
Message Posted: Mon, 15 Apr 2002 @ 14:52:18 GMT
| Subj: || || Re: Are updates generally slow in Teradata |
| From: || || Claybourne L. Barrineau |
If you have the disk space, try creating a temporary new table with the non-updated records and the new updated records (via bteq using
the multi-insert syntax to avoid logging inserts into a table with existing records.) Delete all records from original table then insert new
records from new temporary table into orignal table. Once validated, you can drop the temporary new table.
Hope this helps,