Archives of the TeradataForum
Message Posted: Wed, 08 Mar 2006 @ 20:56:05 GMT
We have a table carrying terabytes of information. We need to load this table on daily basis. There are secondary indices defined on this table, due to this the mloading is very slow.
We suggested following approaches:
Drop the secondary indexes and do the loading, create all the secondary indexes.
But the Secondary index creation takes 4 hours.
Create a table with same schema as base table. Load incremental data in this table with fastload utility. Copy the data from this table to base table.
Please suggest any efficient solution.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|