For active tables in OLTP systems, it is necessary at times to run a reorg to assure the
page chains and indexes are optimized, and unallocated space is freeed.
1> reorg rebuild account_sales
2> go
Beginning REORG REBUILD of 'account_sales'.
There are approximately 15 pages to be processed.
Non-clustered index (index id = 2) is being rebuilt.
REORG REBUILD of 'account_sales' completed.
|
|
