In this module, Guido Verbraak from IBM Expert Labs dives into advanced Db2 object maintenance. He explains how to detect and resolve table and index fragmentation, manage compression degradation, and effectively collect statistics for query optimization. The session covers key tools like REORG, RUNSTATS, and ADMIN_MOVE_TABLE, along with best practices for proactive maintenance, automatic statistics collection, and performance tuning strategies tailored for both row- and column-organized tables.
- Tags
-