Estimating the storage space for the table
The total size of a spatial table is equal to the column sizes plus the dbspace overhead size multiplied by the number of rows.
About this task
To make a rough estimate of the storage space required by the spatial table:
Procedure
- Estimate the number of rows in the table.
- Add the spatial column size, the non-spatial column size, and the dbspace overhead size together.
- Multiply the sum by the estimated number of rows.