Archives of the TeradataForum
Message Posted: Tue, 19 Feb 2013 @ 23:00:46 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|