What is the purpose of the Runstats utility in DB2?
- Creates new indexes
- Performs table reorganization
- Recovers damaged database objects
- Updates statistics for table access paths
The Runstats utility in DB2 is used to update statistical information about the tables, indexes, and columns, which helps the query optimizer to choose the most efficient access paths for retrieving data. This utility does not perform reorganization or index creation. It solely focuses on gathering statistics for better query performance.
Loading...
Related Quiz
- What are the different installation options available in DB2?
- Scenario: A security audit reveals unauthorized access attempts in a DB2 database. What steps should the DBA take to investigate and mitigate potential security risks?
- In denormalization, what action is taken to reduce the number of joins in SQL queries?
- What is the primary purpose of XML and JSON support in DB2?
- What considerations should be made when using views in a distributed DB2 environment?