The index pages associated with a table can add significantly to the size of a dbspace. By default, the database server creates the index in the same dbspace as the table, but in a separate tblspace from the table. To place the index in a separate dbspace, specify the IN keyword in the CREATE INDEX statement. For information about dbspaces and what objects are stored in the tblspace, see the chapter on data storage in your IBM Informix: Administrator's Guide.
Although you cannot explicitly specify the extent size of an index, you can estimate the number of pages that an index might occupy to determine if your dbspace or dbspaces have enough space allocated.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]