Database reorganization has always been about improving database performance and reclaiming free space. However, as Rocket Software software engineer Ka-Chun Ng explained in a recent SHARE presentation, the new capabilities of database management software have changed the “how” and “why” when it comes to reorganization strategy.
Performance is still the big-picture goal, said Ng, but new technologies empower administrators to manage their databases in a more strategic and nuanced way, which improves the efficiency of database management and enables benefits like high availability. To put this all into context, Ng painted a picture of the way weekly database reorganizations are typically run.
Read on for the full story from Ng on the promise and potential for database management.