Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2013 @ 23:00:46 GMT

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

If you want to delete empty partitions, use the Alter Table statement to drop them. There is no performance impact having empty partitions, since there is no data. But you should collect statistics on the keyword partition, so that the optimizer only factors in only populated partitions not all defined partitions.

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