Percentage of free space to be left on index pages
Percentage of free space to be left on index pages
Percentage of free space to be left on index pages
Use this field to specify the percentage of each index page to leave as free space when building the index. The field is initialized with the current PCTFREE value which can be overridden.
The first entry in a page is added without restriction. When additional entries are placed in an index page, the value specified in this field determines the percentage of free space left on each page.
Select a percent from 0 to 99. The default value is 10 percent. If you select a value greater than 10, only 10 percent free space will be left in non-leaf pages.
