14.3 Pages

The following table lists the statuses that a page can have.

Table 14-4 Page statuses

Page statusExplanation
Unused pageAn unallocated page.
Used free pageA page that stores no data because its data has been deleted.#
Used pageA page that stores data but has free space where data can be added.
For tables that are using the free space reusage facility, this includes pages to which data cannot be added because the free space created by deleting data# from the page cannot be used.
Used full pageA page that stores data and has no free space where data can be added.
For tables and indexes that are not using the free space reusage facility, this includes pages to which data cannot be added because the free space created by deleting data from the page# cannot be used.
#
Free space created by data deletion cannot be used until the transaction that executed the data deletion is committed.
Organization of this section
14.3.1 Determining the page length
14.3.2 Setting the percentage of unused space in a page
14.3.3 Allocating and releasing pages