FREESPACE PERCENT | VantageCloud Lake - FREESPACE PERCENT with CREATE TABLE (Table Options Clause)

FREESPACE PERCENT | VantageCloud Lake - FREESPACE PERCENT with CREATE TABLE (Table Options Clause) - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

ft:locale

en-US

ft:lastEdition

2024-12-11

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

For Object File System tables, FREESPACE has a default setting that you cannot change.

FREESPACE = n PERCENT specifies the value for the percent freespace attribute, where n is an integer constant. n percent free space remains on each cylinder during bulk data load operations on the table. PERCENT is an unnecessary keyword and does not affect the semantics of the specification.

Not all database operations use the freespace percentage you specify in a CREATE TABLE statement. The following table lists which operations use the specified freespace percentage and which do not.

Operations That Use FREESPACE	Operations That Do Not Use FREESPACE
FastLoad data loads MultiLoad data loads into unpopulated tables System reconfiguration ALTER TABLE statement that adds fallback protection to a table CREATE INDEX statement that defines or redefines a secondary index on a populated table Creation of a fallback table during an INSERT … SELECT operation into an empty table that is defined with fallback. Creation of a secondary index during an INSERT … SELECT operation into an empty table that is defined with a secondary index.	SQL INSERT operations Teradata Parallel Data Pump INSERT operations MultiLoad data loads into populated tables.

Operations That Use FREESPACE

Operations That Do Not Use FREESPACE

FastLoad data loads
MultiLoad data loads into unpopulated tables
System reconfiguration
ALTER TABLE statement that adds fallback protection to a table
CREATE INDEX statement that defines or redefines a secondary index on a populated table
Creation of a fallback table during an INSERT … SELECT operation into an empty table that is defined with fallback.
Creation of a secondary index during an INSERT … SELECT operation into an empty table that is defined with a secondary index.

SQL INSERT operations
Teradata Parallel Data Pump INSERT operations
MultiLoad data loads into populated tables.

The FREESPACE value returned in response to a SHOW TABLE statement is either the value specified in the CREATE TABLE statement for the table or the value specified by the most recent ALTER TABLE statement.

To change this value after you have created a table or have modified its FREESPACE PERCENT with an ALTER TABLE statement, submit an ALTER TABLE statement to change the free space percent value for the table. See ALTER TABLE Usage Notes (Basic Table Parameters).