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

Leave a comment

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