UPDATE STATISTICS

The UPDATE STATISTICS utility updates statistical information maintained in the dictionary for one or more tables. CA IDMS/DB uses this information when determining the optimal access strategy for processing SQL statements.

Authorization

To update statistics for	You need this privilege	For
A table	ALTER	The table
All tables in an area	DBAREAD	The area
Non-SQL schema	ALTER	All tables processed in the schema