16.10 - Adjusting FREESPACE - Teradata Database

Teradata Database Design

Teradata Database
Release Number
Release Date
June 2017
Content Type
User Guide
Publication ID
English (United States)

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 option 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).