Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 14 May 2002 @ 14:11:33 GMT


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


Subj:   TPUMP and aggregate indexes
 
From:   Ruth Fenwick

Hi All,

I'm looking at exploiting V2R4 features - particularly aggregate indexes. Currently, we daily Mload into tables containing 25 months of data. Dropping and re-creating indexes nightly is probably not a viable option.

I'm looking for any of your experiences with the differences in run times between MLoads and TPump of tables with either join indexes or aggregate indexes on them.

We don't currently own TPump, so if any of you have any benchmark numbers I'd really appreciate any feedback you can give me.


Thanks,

Ruth Fenwick
Hudson's Bay Company



     
  <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: 27 Dec 2016