How does the Reorg utility improve database performance in DB2?
- Deletes unused data
- Reclaims unused space
- Reorganizes data pages and indexes
- Updates data access paths
The Reorg utility reorganizes data pages and indexes, which improves database performance by optimizing the physical storage layout, reducing fragmentation, and reclaiming unused space.
Loading...
Related Quiz
- The Lock Manager in DB2's architecture ensures ________.
- Which type of lock in DB2 allows multiple transactions to read data but prevents them from modifying it?
- Control Center is primarily used for ________ of DB2 databases.
- Which system tables can be queried to gather information about database health in DB2?
- What are some advanced capabilities of IBM Data Studio that differentiate it from other IDEs in the market?