The following table lists the statuses that a page can have.
Table 14-4 Page statuses
Page status | Explanation |
---|---|
Unused page | An unallocated page. |
Used free page | A page that stores no data because its data has been deleted.# |
Used page | A 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 page | A 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. |