SEGSIZE= Table Option

Specifies the size of the segment for an index file associated with an SPD Server table.

Valid in: SPD Server
Default: 8192 table rows

Syntax

SEGSIZE=n

Required Argument

n

the number of table rows to include in the index segment.

Details

The minimum SEGSIZE= value is 1024 table rows. The default value is 8192 table rows. The size of the index segment corresponds to the structure of the table and cannot be changed after the table is created.

Example

Specify a segment size of 64 KB for Mylib.Mytable.
data mylib.mytable (segsize=65536);  
Note: Tests show that increasing the size of the segment does not significantly increase performance.
Last updated: February 8, 2017