What is a page split?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a page split?
Rating:
A page split is a process of splitting an index page. When a new row is inserted and the index page has no space, the page splits into two approximately equal parts. This results in fragmentation, which increases I/O operations. A page split can be reduced by using a fill factor value.
Rating:
Was this information helpful?
Other articles
- What is a file backup?
- What are arguments of the TCP protocol in the CREATE ENDPOINT statement?
- Tip for configuring disks in building clusters.
- What is the RESTORE HEADERONLY statement?
- How to use a table variable?