 |
 |
Archives of the TeradataForum
Message Posted: Thu, 09 Sep 2004 @ 21:16:17 GMT
| Subj: | | Re: Optimizing SQL |
| |
| From: | | Victor Sokovin |
| | 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. | |
I seem to remember from the original posting that the tables involved in the UPDATE were quite small, so, in my opinion, journaling
should not be an issue in this case. I rather agree with other participants that the problem is in the syntax and its compatibility with the
current release.
Regards,
Victor
| |
