Archives of the TeradataForum
Message Posted: Tue, 24 Apr 2007 @ 15:51:31 GMT
The table is already in the database, keep it there. Choose a better PI for the set table. Maybe add a PPI and copy only certain partition. Do some queries to filter out dupes before insert.
Also, if you need to do this all the time (copying 800G from temp table to production table), then maybe the etl process can be improved -- maybe a delta process? Less IO and CPU will benefit all users.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|