Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2003 @ 07:22:06 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Sorry I should explain my terminology.

Free Space Percent (FSP) is the amount of the cylinder that is FREE

Cylinder Fill Factor (CFF) is the amount of the cylinder that is IN USE.

They represent inverse values each other.

FSP + CFF == 100% of the cylinder space.

They can be used interchangably depedning on whether you think of the cylinders as 20% free (FSP) or 80% full (CFF) provided the Abbreviations are provided.

You can set a Table level Attibute called FREE SPACE PERCENT.

alter table blort, FREESPACE = x PERCENT;

that automatically leaves x% free space on the cylinder available for future growth of this table when the table is loaded via multiload or Fastload. That space is then used when you insert, update or delete rows

one at a time
via insert/select
via Merge Into
via TPUMP

	<Prev	Next>		<<First	<Prev	Next>	Last>>