Options to the Modify Procedure
The modify procedure provides several options:
• Min Pages
• Max Pages
• Allocation
• Extend
• Fillfactor
• Leaffill
• Nonleaffill
• Unique
• Compression
The MinPages, MaxPages, Allocation, Fillfactor, Leaffill, and Nonleaffill options take effect during the modify procedure only, but are remembered in the system catalog description of the table. They will be applied again by a future modify-to-reconstruct, and will be output as part of the table description by copydb and unloaddb. The Extend, Unique, and Compression options are continuously active throughout the life of the table.
In VDBA, these options are in the Structure of Table and Structure of Index dialogs.