Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Mload performance issue due to Secondary indexes
From:   Samarsingh_Chauhan

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.



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020