map fixed length to variable

Map fields with a fixed length storage format (CHAR) to a variable length storage format.

USYS$PGS_PARAMS = map fixed length to variable :on | off

USYS$PGS_PARAMS = fv:on | off

Description

If the setting is not specified, it defaults to off.

This setting can greatly reduce the disk space required for large table sets. However, it may also reduce the database performance by 20%-50%.

Related Topics