Page headers and page sizes

All pages have a header that stores information such as the object ID that the page belongs to and other information used to manage space on the page. Table 7-1 shows the number of bytes of overhead and usable space on data and index pages.

Table 7-1: Overhead and user data space on data and index pages

Locking Scheme

Overhead

Bytes for User Data

Allpages

32

2016

Data-only

46

2002

The rest of the page is available to store data and index rows.

For information on how text, image, and Java columns are stored, see “Large Object (LOB) Pages”.