Sample Header Ad - 728x90

Page split where existing rows are moved to different page occurs only for updates and non-sequential inserts?

0 votes
3 answers
334 views
Suppose page is full, and an item is inserted in order, then that item will get added to the next page. There will never be page split such that some rows are placed on a page and some rows move to another page. Where as if an update is performed such that an item needs to be placed somewhere in an already full page, then a page split happens where some rows are kept of this page and other rows are moved to a new page. So a page split where **existing** rows are moved to different page occurs only for updates and non-sequential inserts?
Asked by variable (3590 rep)
Mar 1, 2022, 05:40 PM
Last activity: Mar 2, 2022, 12:27 AM