The index pages associated with a table can add significantly to the space required in a dbspace. Although an attached index for a table is stored in a different tblspace, it is stored in the same dbspace as the table. A detached index is stored in different dbspaces that you specify. To estimate the amount of space required by an index, use the calculations described in this section.
To determine the index extent size, the database server uses the extent size of the table, the index key length, and the table row size. The formula for estimating the index extent size is as follows:
Index extent size = table extent size * ((key length + 8)/row size)
The minimum extent size is four pages.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]