Archives of the TeradataForum

Message Posted: Mon, 27 Mar 2006 @ 18:32:00 GMT


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

Subj:		Re: PPI Range Maintance

From:		Keith_kdb

Fachtna,

I recently managed a database with a number of large tables with PPI defined. We managed the advancement of the PPI partitions using metadata and stored procedures. The reason we used this method was due to the number of tables with PPI and the fact that we chose to run the process monthly (a number of tables were partitioned daily). This allowed the process to be scheduled and run frequently - hopefully avoiding the situation whereby it was forgotten to be run and help ensure it runs smoothly.

With regard to stats, be careful. If you load data that populates a new partition and you don't collect stats on the partition column, you will almost certainly get some BAD plans as the optimizer expects zero rows from that partition.

Regards

Keith.


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