Archives of the TeradataForum
Message Posted: Fri, 13 Jan 2012 @ 23:09:23 GMT
| Subj: | | Re: When to recollect stats? |
| |
| From: | | Dieter Noeth |
Joe Gleason wrote:
| | Do you want to recollect on row counts or perm space changes? Can you list the pros and cons of each? I collect on currentperm changing
by more than 10% but would like to hear why row counts might be better... | |
To base it on perm space you need to maintain a space history (of course this might be already in place) and table size changes when an index
is added/dropped.
Row count is based on previous stats (no history neccessary) and for partitioned tables it can detect when the number of partitions or the
maximum partition row count changed.
Dieter
| 
