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 8-1 shows the number of bytes of overhead and usable 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”.
