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.
|Operations That Use FREESPACE||Operations That Do Not Use FREESPACE|
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.
Instead, submit an ALTER TABLE statement to change the free space percent value for the table and then immediately afterward submit a PACKDISK command that specifies the same free space percent value you set with that ALTER TABLE statement. See ALTER TABLE (Basic Table Parameters). For information about running PACKDISK, see the Ferret utility in Teradata Vantage™ - Database Utilities , B035-1102 .
If you manually submit a PACKDISK command and specify a free space percentage on the command line, PACKDISK packs or unpacks the cylinders for the table to match the specified free space percentage. However, if the free space percentage you specify differs from the value specified for the table when it was created or last altered, Teradata Database starts a new AutoCylPack task immediately after PACKDISK completes, and this AutoCylPack operation nullifies the free space percentage you had just specified with PACKDISK to realign it with the free space percentage specified when you created or last altered the table.