The Runstats utility collects statistics about ________ in DB2.
- Database objects
- Indexes
- Stored procedures
- Tables
The Runstats utility in DB2 collects statistics about various database objects such as tables, indexes, columns, and partitions. These statistics help the query optimizer to make informed decisions about the most efficient way to access data, leading to improved query performance.
Loading...
Related Quiz
- Scenario: A company is planning to migrate its database to a cloud environment. What are the considerations for implementing data compression and encryption in DB2 on the cloud?
- In DB2, a table defines the ________ of a database object.
- How does the DEFERRABLE constraint affect the timing of constraint checking in DB2?
- What does DB2 offer in terms of scalability?
- In DB2, what is the difference between shared locks and exclusive locks?