Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 06 Mar 2011 @ 08:29:47 GMT


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


Subj:   Partitioned Primary Indexes (PPI) -- Altering
 
From:   Iqbal Shaheryar

Hi,

The most obvious use for the partitioning would be DATE. Based on the kind of queries we currently receive, the ranging would be something like.

Current Date to 14 days ago, split by DAY

2 weeks ago to 16 weeks ago, split by WEEK

prior to 16 weeks ago, split by MONTH


Now I know this can be done.

My questions is regards to keeping this range a moving window.

I understand that it would be necessary to perform an ALTER TABLE on a regular basis to keep the above scenario. Can this be automated, so each day, the systems automatically moves the range windows. Can you use the CURRENT_DATE function or do you need to specify a constant date.

Or how can a DBA maintain this as a manual process?


Thanks,

Shaheryar.



     
  <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