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 Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023