Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 05 Nov 2002 @ 00:19:23 GMT





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




Subj:   Re: Secondary Indexes on an Active Data Warehouse
 
From:   Christian Schiefer



Hi,

we are facing a similar situaton: Loading with a 5 x a day a FLIS (Fastload Insert Select ). You either go for load performance (NO SIs) or for user availability and performance. Normally you're better of leaving the SI's as they are, because in the rebuilding the SIs, there is no row locking .....





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008