The table tblspace and index tblspace contain certain types
of pages.
The table tblspace contains the following types of pages:
Pages allocated to data
Pages allocated to indexes
Pages used to store TEXT or BYTE data in the dbspace (but not
pages used to store TEXT or BYTE data in a blobspace)
Bitmap pages that track page use within the table extents
The index tblspace contains the following types of pages:
Pages allocated to indexes
Bitmap pages that track page use within the index extents
The following table illustrates the tblspaces for three tables
that form part of the stores_demo database. Only one table
(or table fragment) exists per tblspace. Blobpages represent TEXT
or BYTE data stored in a dbspace.Figure 1: Sample tblspaces in the stores_demo database