Archives of the TeradataForum
Message Posted: Wed, 04 May 2011 @ 09:24:04 GMT
Hi. How can I locate (1) all tables that have a PPI and (2) do not have Statistics collected on the partition?
Also, should I collect statistics for BOTH the partition column AND the partition? E.g.
COLLECT STATISTICS TableName COLUMN PartitionColumnName; COLLECT STATISTICS TableName COLUMN (PARTITION);
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|