Archives of the TeradataForum
Message Posted: Wed, 12 Mar 2003 @ 20:00:37 GMT
| Subj: || || Stats on the PI |
| From: || || Anomy Anom |
<-- Anonymously Posted: Wednesday, March 12, 2003 14:55 -->
I have read that you should collect stats on the PI of only small tables. Why only small tables? Does it hurt to collect stats on the
PI of a large table?
Also someone said "If you don't have stats on the PI of a table then the optimiser will ignore any other stats that are collected on the
table." If that is true and you are not suppose to collect stats on the PI of a large table then don't we have a problem here?