Table and Index Modification and Performance
You can modify a table or index to:
• Reorganize data on new data pages
• Free deleted record space
• Reduce overflow chains
• Adjust the fill factor
Use the Shrink B-tree Index option (or MODIFY TO MERGE statement) to:
• Reorganize index pages of B-tree tables
• Reduce overflow chains
Use the Change Location option (or MODIFY TO RELOCATE statement) to move your tables to balance disk access.
To perform modification, use the MODIFY statement, Actian Director, or in VDBA use the Modify Table Structure and Modify Index Structure dialogs.