Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 07 Oct 2009 @ 08:37:17 GMT


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


Subj:   T12: Limit on Partitions?
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, October 07, 2009 01:47 -->

We have a table on which partition is defined as follows:

     PARTITION BY RANGE_N(PROC_DATE
        BETWEEN DATE '1999-07-01' AND DATE '2020-02-01'
        EACH INTERVAL '1' DAY )

Here interval is 1 day, that means a partition would be created for each day's data.

My questions are:

1. Will not be too many partitions create performance problem?

2. Are there not any limit on no of partition in Teradata.

3. This partition would be helpful in data load as data would be loaded for each partition, but would not range queries suffer in some way? (I am just guessing on this.)


We are using Teradata 12.

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