Home | Previous Page | Next Page   Appendix A. Estimating Table and Index Size >

Table Size Estimates

This section describes how to calculate the approximate number of disk pages required for tables.

After you have estimated the total table size, refer to Planning Table and Index Fragmentation, for information about fragmenting the table across the coservers in your database server.

The disk pages that are allocated to a table or table fragment are collectively referred to as a tblspace. Attached index pages and pages that store BYTE or TEXT data are stored in separate tblspaces in the dbspace that contains the associated data pages of the table.

The tblspace does not correspond to any single physical region in the chunks assigned to the dbspace. The data extents and indexes that make up a table can be scattered through the dbspace.

The following sections describe how to estimate the page count for each type of page associated with a table.

Tip:
If an appropriate sample table already exists, or if you can use simulated data to build a sample table of realistic size, you do not need to estimate. You can run onutil CHECK INFO IN TABLE to obtain exact numbers.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]