When should the Reorg utility be used in DB2?
- After extensive data deletion
- To create a new table space
- To optimize SQL queries
- To update database schema
The Reorg utility in DB2 is typically used after extensive data deletion, which leaves the table fragmented. Reorganization rearranges the data physically, eliminating fragmentation and reclaiming space, thus improving performance. It's not used to create new table spaces, update schema, or optimize queries.
Loading...
Related Quiz
- Scenario: A developer needs to retrieve only specific records from a database table in a particular order. Which SQL clause should they use?
- DB2 handles transactions involving cursors by ensuring ________.
- Which DB2 feature helps to enforce data integrity by automatically updating related data?
- Which SQL command is used to add new records to a table?
- How does DB2 integrate with other technologies?