What does the Reorg utility do to database objects in DB2?
- Creates new tables
- Deletes obsolete rows
- Reorganizes data and indexes
- Updates table statistics
The Reorg utility in DB2 reorganizes both data and indexes in database objects. It rearranges the physical storage of data, eliminating fragmentation and reclaiming space, which helps in improving performance. Additionally, it also updates statistics for these objects. It does not create new tables or delete obsolete rows.
Loading...
Related Quiz
- Encryption in DB2 ensures data ________.
- In DB2, a stored procedure can be used to encapsulate ________ logic.
- How do different versions of DB2 impact compatibility with existing applications?
- Which data type is used to store whole numbers in DB2?
- What are the advantages of using a scrollable cursor in DB2?