Archives of the TeradataForum
Message Posted: Thu, 29 Mar 2007 @ 09:25:39 GMT
| Subj: | | Partition Statistics |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Wednesday, March 28, 2007 14:48 -->
I am trying to determine how to make use of the partition statistics feature. According to the Teradata user documentations, single-column
partition does not need to collect separate partition statistics in addition to the partitioning column (if this column has individual column
stats). Is it true that only multicolumn partitions will need to collect the partition stats?
I am also wondering if partition statistics is collected, will it still scan the full table even though new data is only inserted into the last
partition.
| 
