The following list reviews the principal points to remember about estimating the table space requirements for your new database.
- Accurate estimates require accurate base data. The minimum base data required for these estimates are the following.
- Cardinalities (or anticipated cardinalities) of your tables
- Row size estimates
Each row length must be an even number of bytes (see Byte Alignment), so be sure to take this into account.
- Estimate sizes for all the following database objects.
- Base tables
- Base table fallback tables (when defined)
- LOB and XML subtables
- Secondary indexes
- Secondary index fallback tables (when defined)
- Join indexes (including any secondary indexes defined on them)
- Join index fallback tables (when defined)
- Spool space
- Procedures