Utility Statements › UPDATE STATISTICS › UPDATE STATISTICS Parameter

UPDATE STATISTICS Parameter

FOR

Identifies the tables or areas for which the UPDATE STATISTICS utility is to update statistics.

TABLE

Specifies one or more SQL-defined tables and non-SQL defined tables for which the UPDATE STATISTICS utility is to update statistics.

schema-name

Specifies the name of the schema associated with the named table.

table-identifier

Specifies the identifier of a base table defined in the dictionary.

AREA

Updates statistics for all the tables in one or more SQL-defined areas. If one of the specified areas is non-SQL-defined, error message DB002316 is displayed which indicates that the area is NOT a relational area. In this case, specify the areas through the SCHEMA-clause of the UPDATE STATISTICS utility.

segment-name

Specifies the name of the segment associated with the area.

area-name

Specifies the name of the area.

SAMPLE

Specifies the percentage of the pages in an area that the UPDATE STATISTICS utility is to examine when calculating statistical information about one or more tables in the area.

percent

Specifies an integer in the range 1 through 100.

By default, if you do not specify a percentage, the UPDATE STATISTICS utility will examine all the pages in the specified area.

SCHEMA schema-name

Identifies the schema for which statistics are updated. The identified schema must be SQL-defined and can reference a non-SQL-defined schema.

AREA area-name

Identifies one or more areas of the identified schema for which statistics are to be updated.