A spatial data value is stored in row if the value is less
than or equal to 930 bytes. However, if the value is greater than
930 bytes, only a pointer of 64 bytes is stored in row. This pointer refers to
the smart large object in which the actual data is stored.
About this task
Important: Store sbspaces on a disk separate
from both the table and the indexes.
To estimate the amount
of smart large object storage space:
Procedure
-
Determine the smart large object ratio using the following
formula:
smart large object ratio = (spatial column size / 1920)
The smart
large object ratio cannot be greater than 1. So if the smart large
object ratio you calculate is greater than one, set it to 1.
-
Multiply your smart large object ratio by the number of
rows in your table to obtain the amount of smart large object space
used by your table:
smart large object space = ( ( smart large object ratio ) *
number of rows)
-
Determine the amount of in-line table space required using
the following formula:
in-line space = (size of spatial table) - (smart large object space)