Logging Behavior

Default incremental reorganization logging includes the extent allocation, extent version update, index row deletion, index row insertion, extent deallocation, and scan position update, in that order.

This logging sequence ensures complete recoverability of the reorganization. However, this sequence may not enforce the dump tran sequence.

Turn on either full logging for reorg rebuild or the general full logging for all options in the existing database to ensure that the incremental reorganization enforces the dump tran sequence, an extra log of the page image is required for every destination data page created by the reorganization.

The default logging behavior consumes the following log space by reorg defrag: