Table and index tblspaces

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
This figure shows the tblspaces data for three tables in the stores_demo database. Each of these tblspaces contains data pages and a bitmap page. The figure also shows the index tblspaces for three same tables. Each index tblspace contains index pages and a bitmap page.

Copyright© 2019 HCL Technologies Limited