Kbase P115516: What tables are updated when an Update Statistic is run?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/12/2009 |
|
Status: Verified
GOAL:
What tables are updated when an Update Statistic is run?
GOAL:
What system tables are updated during Update Statistics?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
The sql statistics are stored in a series of system tables in the database
table statistics - _systblstat
index statistics - _sysidxstat
column statistics - _syscolstat,
and 1 table for each datatype:
_sysnvarcharstat
_sysintstat
_sysnumstat
_sysdatestat
_sysrealstat
etc.