Archives of the TeradataForum
Message Posted: Thu, 03 Sep 2009 @ 09:01:42 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|