Archives of the TeradataForum

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

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

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>>