1.

What are the primary differences between an index reorganization and an index rebuild?

Answer»

Index Reorg

  • The reorganization is an "online" operation.
  • Reorganization only AFFECTS the LEAF LEVEL of an index
  • Reorganization shuffle data place to rectify existing allocated pages of index
  • The reorganization is always a fully-logged operation
  • Reorganization can be stopped or killed any TIME, no need for a rollback

Index Rebuild

  • Rebuild is an "offline" operation by default.
  • Rebuild creates a completely new structure of index B-Tree
  • Rebuild uses new pages/allocations
  • Rebuild can be a minimally-logged operation
  • Rebuild can be stopped or killer but it requires rollback to complete TRANSACTIONALLY


Discussion

No Comment Found