PPT Slide

The daily grind

Fragmentation and Reorganization

Fragmentation schemes and reorganization

• Best reason to fragment is to manage data and history better.

• Easy to add new, empty, fast fragment for newer data.

• Easy to move older data to slower cheaper structures.

• Easy to detach older data to history tables to further improve performance against critical records.

Previous slide

Next slide

Back to first slide

View graphic version