Utility Statements › UPDATE STATISTICS › Example

Example

Updating statistics for specified tables

The following UPDATE STATISTICS statement updates statistics for the MONTHLY_BUDGET and PROPOSED_BUDGET tables in the PROD schema. Since no percentage has been specified, the UPDATE STATISTICS utility will examine all the pages in the area associated with each table when calculating the statistics.

update statistics
   for table prod.monthly_budget, prod.proposed_budget;

Updating statistics for all the tables in an area

The following UPDATE STATISTICS statement updates statistics for all the tables in the SQLDEMO.EMPLAREA area.

update statistics
   for area sqldemo.emplarea;