Archives of the TeradataForum

Message Posted: Tue, 18 Dec 2012 @ 14:18:42 GMT

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

If the partitions are empty, there is nothing to scan. There is not reserved space for the empty partitions. But you should always collect stats on the keyword partition. It is very fast, and will tell the optimizer how many partitions are populated so the optimizer can be more aggressive in the plan it chooses.

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