MODIFY NEXT SIZE clause
Use the MODIFY NEXT SIZE clause to change the size of the next extent.
Element | Description | Restrictions | Syntax |
---|---|---|---|
kilobytes | Length (in kilobytes) assigned here to the next extent for this table | Specification cannot be a variable, and (4(page size)) < kilobytes < (chunk size) | Expression |
ALTER TABLE customer MODIFY NEXT SIZE 32;
This clause cannot change the size of existing extents. You cannot change the size of existing extents without unloading all of the data.
To change the size of existing extents, you must unload all the data, drop the table, modify the first-extent and next-extent sizes in the CREATE TABLE definition in the database schema, re-create the table, and reload the data. For information about how to optimize extent sizes, see your HCL OneDB™ Performance Guide.