Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 02 Jun 2005 @ 17:03:13 GMT


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


Subj:   PPI table - empty partitions.
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, June 02, 2005 11:54 -->

Hello all,

Will there be a problem if we have too many empty partitions in a PPI table. We are planning to partition a table based on date. We are planning to have partitions for very broad range of dates to avoid maintenance. There are chances of having empty paritions for previous years as data gets purged.

Most of the time users go by date. Will there be any degradation in performance especially if there is no condition on partition column and all rows scan has to be performed. Have any one heard of any problems?


Thanks



     
  <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