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

  1. Estimate the number of rows in the table.
  2. Add the spatial column size, the non-spatial column size, and the dbspace overhead size together.
  3. Multiply the sum by the estimated number of rows.