The SE_InRowSize() function

The SE_InRowSize() function returns the size of the in-row portion of a geometry. Geometries which are less than 930 bytes are stored entirely in-row: that is, the entire value is stored in a table's dbspace.

The SE_InRowSize() function returns the size of the in-row portion of a geometry. Geometries which are less than 930 bytes are stored entirely in-row: that is, the entire value is stored in a table's dbspace.

You can use this function to obtain an estimate of the amount of disk space consumed by one or more geometries. However, this function does not account for dbspace and sbspace overhead, so cannot be used to obtain an exact total.

Syntax

SE_InRowSize(ST_Geometry)

Return type

INTEGER

See also

The SE_OutOfRowSize() function

The SE_TotalSize() function