What are Page Splits?

What are Page Splits?

- When there is not enough room on a page for a new row, a server splits the page, allocates a new page, and moves some rows to the new page.
- It arises when records from one memory page are moved to another page during changes to your table.
- Page splits are considered as a very bad performance and there are number of techniques which is used to reduce the risk of page splits.
Describe in brief database architecture
Database architecture describes the design of the database. It explains how the data is stored. The data of the server is stored in databases.......
Explain logical database components
The logical components are usually used to connect to the database. Any object that a user can use to......
What are the database objects? Explain them in brief
Database objects such as tables, primary key, and foreign key describe the structure of the content of a database. These objects also represent the properties of a server.....
Post your comment

Related Content

Follow us

▲