This section reports more detail on updates to data-only-locked tables:
DOL Replace – The update did not change the length of the row; some or all of the row was changed resulting in the same row length
DOL Shrink – The update shortened the row, leaving non contiguous empty space on the page to be collected during space reclamation.
DOL Cheap Expand – The row grew in length; it was the last row on the page, so expanding the length of the row did not require moving other rows on the page.
DOL Expensive Expand – The row grew in length and required movement of other rows on the page.
DOL Expand and Forward – The row grew in length, and did not fit on the page. The row was forwarded to a new location.
DOL Fwd Row Returned – The update affected a forwarded row; the row fit on the page at its original location and was returned to that page.
The total reported in “Total DOL Rows Updated” are not included in the “Total Rows Affected” sum at the end of the section, since the updates in this group are providing a different breakdown of the updates already reported in “DOL Deferred” and “DOL Direct.”
