You can view and update statistics for data objects, such as tables and views. Not all objects and target servers are supported for statistics.
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 |