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. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *