Location of Rows

When the database server receives a row that is longer than a page, the row is stored in as many whole pages as required. The database server then stores the trailing portion in less than a full page.

The page that contains the first byte of the row is the row home page. The number of the home page becomes the logical page number contained in the rowid. Each full page that follows the home page is referred to as a big-remainder page. If the trailing portion of the row is less than a full page, it is stored on a remainder page.

After the database server creates a remainder page to accommodate a long row, it can use the remaining space in this page to store other rows.

Figure 1 illustrates the concepts of home page, big-remainder page, and remainder page.
Figure 1. Remainder Pages
begin figure description - The paragraph that precedes this figure describes the content of the figure. - end figure description

Copyright© 2019 HCL Technologies Limited