APPENDIX B
Page Splitting and Page Merging in Nonclustered Indexes
This appendix provides an overview of nonclustered index internal operations, such as page splitting and page merging.
Nonclustered Indexes Internal Maintenance
The In-Memory OLTP Engine has several internal operations to maintain the structure of nonclustered indexes. As you already know from Chapter 5, page consolidation rebuilds the nonclustered index page, consolidating all changes defined by the page delta records. It helps avoid the performance hit introduced by long delta record chains. The newly created page has the same PID in the mapping table and replaces the old page, ...
Get Expert SQL Server In-Memory OLTP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
