Progress
SQL-92
Guide and Reference


UPDATE STATISTICS Statement

Queries data tables and updates the following table and column statistics:

SYNTAX

UPDATE STATISTICS [ FOR table_name ] ; 

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

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