Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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:

        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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020