Kbase P122974: Where to find information on the Progress SQL-92 system catalog tables
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/01/2011 |
|
Status: Verified
GOAL:
Where to find information on the Progress SQL-92 system catalog tables
GOAL:
Where to find information on tables that store information related to update statistics
GOAL:
Where to find what information is contained in the sysprogress tables.
GOAL:
Where is a list of the sysprogress tables.
FIX:
You can find limited information on what the sysprogress tables contain by referencing our SQL-92 Guide and Reference Manuals. The Progress SQL-92 Guide and Reference Manual for Version 9 and version 10 have the information in different locations: Progress SQL-92 Guide and Reference Manual, version9;Appendix B, "Progress SQL-92 System Catalog Tables", and OpenEdge Data Management, 10.1B SQL Reference:"OpenEdge SQL System Catalog Tables". Please refer to solution 20992 for an explanation of update statistics and to solution P115516 for a list of tables updated by update statistics at a point in time. The information is limited , since the information gathered in the sysprogress tables can change as can how the information is gathered and also what tables/columns may be used going forward.