Database statistics support

You can view and update statistics for data objects, such as tables and views. Not all objects and target servers are supported for statistics.

Statistics can be viewed for the following object types:
Server Object type RUNSTATS option
DB2® for Linux®, UNIX®, and Windows® or DB2 for z/OS® Table On the selected table, for all columns and indexes
DB2 for Linux, UNIX, and Windows or DB2 for z/OS Materialized query tables (MQTs) For the selected MQT
DB2 for Linux, UNIX, and Windows or DB2 for z/OS Index For the selected index
DB2 for Linux, UNIX, and Windows or DB2 for z/OS Column For the selected column
DB2 for Linux, UNIX, and Windows Routine (stored procedure or user-defined function) For the selected routine
DB2 for Linux, UNIX, and Windows, Version 9.1 and higher Nickname For the selected nickname
DB2 for z/OS Storage group For the selected storage group
DB2 for z/OS Table space On the selected table space, for all tables and indexes