 |
 |
Archives of the TeradataForum
Message Posted: Thu, 09 Sep 2004 @ 20:13:56 GMT
| Subj: | | Re: Optimizing SQL |
| |
| From: | | Czajkowski, Al |
| | I am trying to find a way to speed up this SQL. | |
Create a third table and change the update to populate the new table. When the load is complete rename the tables. Your workload is slowed
down because of transient journaling. Insert to an empty table will be very quick. You also get a little insurance incase something is wrong
with the update - you can roll back to the old table.
Electronically,
Al Czajkowski
| |
