Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 03 Sep 2009 @ 09:01:42 GMT


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


Subj:   Partitionin in Teradata 12.
 
From:   prahlad.k.patidar

Hi,

We have Teradata 12 installed and one of table is partitioned in following way. For over 20 years' data is being partitioned and each partion is of a single day.

     UNIQUE PRIMARY INDEX UPI_N( BM_KEY ,
     BP_DATE ,BMT_CODE )
     PARTITION BY RANGE_N(BP_DATE  BETWEEN DATE '1999-07-01' AND DATE
     '2020-02-01' EACH INTERVAL '1' DAY )

My questions are:

1. Will it not impact query performances, inserts and selects?

2. Will all the partitions be created at the time of table creation, it means most of the partions would be lying empty. Would this impact performance in any way?

3. should we create all partition on day one as above or keep adding partition as and when required?


Regards

Prahlad Patidar



     
  <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