Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2002 @ 18:02:10 GMT


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


Subj:   Re: Secondary Indexes on an Active Data Warehouse
 
From:   Jim Downey

Matthew,

Can you load into a copy of your base table. This copy would contain only 'today's data. Would it perform adequately without the secondary indexes? At the end of the day, you copy 'Today's data into the base table.

Can you load todays data into 3 copies of the base table. Each table would have as its PI your secondary index criteria.

Jim



     
  <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: 28 Jun 2020