Extension of Space
The Extend option allows you to control the amount of space by which a table is extended when more space is required. (The default extension size is 16 pages.)
The size must be in the range 1 to max_size, where the max_size is calculated as:
8,388,607 – allocation_size.
The specified Extend size is rounded up, if necessary, to make sure the size for a multi-location table or index is always a multiple of sixteen.
Note: If the specified number of pages cannot be allocated, the operation fails with an error.
After an extend size has been specified for the table or index, it remains in effect and does not need to be specified again when the table or index is modified.
Example: Extend a Table in Blocks of 1000 Pages
The following example specifies that the table inventory be extended in blocks of 1000 pages:
modify inventory to btree with extend = 1000;
In VDBA:
1. Open the Structure of Table dialog for the table.
2. Select B-tree from the Structure drop-down list.
3. Enter 1000 in the Extend edit control.
The extension space is 1008, due to rounding.