Kbase P92576: When to perform an update column statistics
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/09/2004 |
|
Status: Unverified
GOAL:
When to perform an update column statistics
FACT(s) (Environment):
Progress 9.0x
OpenEdge 10.0x
FIX:
If a substantial portion of data is added, removed or modified within a table and the typical means of record selection for the table is by range match constraint then use the update column statistics option to update the query selection pattern.
The syntax for the command is:
update column statistics for [tablename];
commit;
If necessary, remember to prefix the table name with "pub."