ALLBASE/SQL Reference Manual (36216-90216)

586 Chapter12

SQL Statements S - Z

UPDATE STATISTICS

• The only views this statement works for are system views. Refer to the

ALLBASE/SQL

Database Administration Guide

for a description of the system views.

• UPDATE STATISTICS

cannot

be used with pseudotables — SYSTEM.ACCOUNT,

SYSTEM.CALL, SYSTEM.COUNTER, SYSTEM.TRANSACTION, and

SYSTEM.USER.

• You may ﬁnd it convenient to use the VALIDATE statement after an UPDATE

STATISTICS. If you issue both statements during a period of low activity for the

DBEnvironment, the optimizer will have current statistics on which to base its

calculations, with minimal performance degradation.

Authorization

You can issue this statement if you have OWNER authority for the table or if you have

DBA authority.

Example

You issue this statement after periods of heavy data update activity in order to keep access

paths optimal.

UPDATE STATISTICS FOR TABLE PurchDB.Orders