11. Maintaining Storage Structures : Modify Procedures : Extending a Table or Index
 
Share this page                  
Extending a Table or Index
You can extend (add pages to) a table or index. You must specify the number of pages you want to add. Using this option does not rebuild the table or drop any secondary indexes.
In VDBA, you can extend a table or index by enabling the Add Pages radio button in the Modify Table Structure or Modify Index Structure dialogs and specifying the number of pages to add.
In SQL, you can accomplish this task with the MODIFY statement. The WITH EXTEND clause is the same as the Add Pages option. For more information, see the SQL Reference Guide.