Index Enhancements   «Prev 

Minimize RECORDS_PER_BLOCK

Alter TABLE table_name MINIMIZE/NOMINIMIZE 
RECORDS_PER_BLOCK

ALTER TABLE   Required keywords.
table_name   The unique name of the table.
MINIMIZE/NOMINIMIZE   You must use one of these keywords. NOMINIMIZE is the default.
RECORDS_PER_BLOCK   Required keywords.

Oracle Systems

Many Oracle systems store rows as small and then expand them with SQL UPDATE statements causing the rows to fragment into multiple blocks.
To prevent the inevitable row migration that results from extreme row size expansion, I set PCTFREE to a high value whenever rows are stored small, and later expanded.