Archives of the TeradataForum

Message Posted: Fri, 06 Feb 2004 @ 14:26:12 GMT

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

What's the current thinking on how many "empty" partitions it is sensible to pre-create (for future data) on an active data warehouse table that has a date based PPI?

Are there any known performance implications of creating 2/3 years of empty weekly partitions?

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