Chapter 9: Using the reorg Command

Performance characteristics

Index scans traverse faster after you run reorg.

Running reorg against a table can have a negative effect on performance of concurrent queries.