Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 13 Jun 2013 @ 17:57:07 GMT


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


Subj:   Re: Drop Indexes before load or insert
 
From:   Walter, Todd

Depends on how much data is already there. If you are inserting/updating a large percentage, then it might be a good trade off. But for small percentages it is going to be less costly overall to let the load take longer rather than take the time afterward to build the indexes and collect stats on them from scratch.



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