Table and Index Tblspaces

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

Figure 48 illustrates the tblspaces for three tables that form part of the stores_demo database. Only one table (or table fragment) exists per tblspace. An index resides in a separate tblspace from the associated table. Blobpages represent TEXT or BYTE data stored in a dbspace.

Figure 48. Sample Tblspaces in the stores_demo Database