Archives of the TeradataForum

Message Posted: Wed, 08 Mar 2006 @ 20:56:05 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi All,

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.

Regards,

Samar

	<Prev	Next>		<<First	<Prev	Next>	Last>>