Kbase P113929: Is it recommended to run Update Column Statistics as well as Update Table and Index Statistics?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/30/2008 |
|
Status: Verified
GOAL:
Is it recommended to run Update Column Statistics as well as Update Table and Index Statistics?
GOAL:
What does Update Column Statistics do?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
Update Table and Index statistics are the most important. Column Statistics are most useful for "range predicates", i.e. using comparison operators such as Between, >, <, etc. Column Statistics are also useful for = comparisons on columns which are not used for indexing.