15.00 - Adjusting FREESPACE - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Adjusting FREESPACE

You can specify the default value for free space left on a cylinder during certain operations on a table-by-table basis by specifying the FREESPACE parameter in the CREATE TABLE and ALTER TABLE requests.

This parameter enables you to select a different value for tables that are constantly modified versus tables that are only read after they are loaded. To specify the global free space value, use the FreeSpacePercent command of the DBS Control utility (see “FreeSpacePercent” in Utilities: Volume 1 (A-K)).