FREESPACE - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

The percentage of free space to reserve on a cylinder during some loading operations.

The following operations use the FREESPACE setting you specify:
  • FastLoad data loads.
  • MultiLoad data loads into empty tables.
  • Archive/Recovery RESTORE.
  • Table Rebuild.
  • System reconfiguration
  • Ferret PACKDISK.
  • MiniCylPack.

    If few cylinders are available and storage space is limited, MiniCylPack might not be able to honor the specified FREESPACE value.

  • ALTER TABLE request that adds fallback protection to a table.
  • CREATE INDEX request 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.
The following operations do not use the FREESPACE setting you specify:
  • SQL INSERT operations.
  • Teradata Parallel Data Pump INSERT operations.
  • MultiLoad data loads into populated tables.
You cannot use PACKDISK to change this attribute after you have created a table. Instead, submit an ALTER TABLE request to change the free space percent value for the table and then immediately afterward submit a PACKDISK command using the same free space percent value. See ALTER TABLE. For more information and instructions for running PACKDISK, see the description of the Ferret utility in Teradata Vantage™ - Database Utilities , B035-1102 .
integer
Value from 0 through 75, representing a percentage. DECIMAL or FLOATING POINT constants are converted to an integer by truncating the value.
PERCENT
An optional keyword you can type following the value for integer.