Archives of the TeradataForum
Message Posted: Fri, 01 Mar 2002 @ 14:39:54 GMT
I note you are appending rows - each will be journalled and the time taken becomes evident on thousands of rows. In addition to the suggestions already made, consider loading to a (temporary) empty table. Then merge the old table and the temporary table into a new table with a single journal entry.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|