Kbase P92575: When to perform an update index statistics
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/05/2010 |
|
Status: Verified
GOAL:
When to perform an UPDATE INDEX STATISTICS
GOAL:
How to execute a UPDATE INDEX STATISTICS
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
If a substantial portion of data is added, removed or modified within a table and the typical method of record selection for the table is by uniqueness constraint then use the update index statistics function to update the query selection pattern.
The syntax for the command is:
UPDATE INDEX STATISTICS FOR [tablename];
COMMIT;
Remember to prefix the table name with "pub." if table was created using 4GL side/ Progres Data Dictionary.