Wei Cao – IBM
Abstract
Table and index fragmentation can be DBA’s worst nightmare as databases grow and evolve over time, resulting in inefficient storage utilization and degraded query performance. This session aims to provide a comprehensive overview of Db2 tables and REORG process, best practices for identifying when reorganization is necessary, factors to consider when choosing the right type of REORG, and ways to automate the process for seamless maintenance. This presentation will equip you with the knowledge and strategies needed to enhance your Db2 LUW performance tuning approach.
Speaker Bio
Wei Cao is a Senior Development Manager in the Db2 organization responsible for Db2 Kernel domain.