Progress
SQL-92
Guide and Reference
UPDATE STATISTICS Statement
Queries data tables and updates the following table and column statistics:
SYNTAX
table_name
Specifies a single table on which to update statistics. If you do not specify a table_name, the
UPDATE STATISTICS
statement updates statistics on all tables in the database.NOTES
- The time required to gather the statistics is highly dependent on the number of tables specified and on the number of rows in those tables.
- The optimizer uses the information from UPDATE STATISTICS to make decisions about the best query strategy to use when executing a particular SQL-92 statement.
- Until a user, application, or SQL-92 script issues an UPDATE STATISTICS statement, the optimizer bases query strategies on values it derives from various defaults. These values might not lead to the best performance, so database administrators should issue an UPDATE STATISTICS operation periodically.
AUTHORIZATION
Must have DBA privilege, SELECT privilege, or ownership of table (to issue UPDATE STATISTICS statement for a specific table).
SQL COMPLIANCE
Progress Extension
ENVIRONMENT
Embedded SQL, interactive SQL, ODBC applications, JDBC applications
RELATED STATEMENTS
None
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |