The REORGANIZE syntax of the ALTER TABLE statement is used to request a table be reorganized for performance improvement.
For this release, the ALTER TABLE REORGANIZE feature combines multiple smaller objects (produced as part of INSERT operations into the Object File System table) into a larger set of objects. This improves data read performance on the table for future queries.
ALTER TABLE [ database_name. ] table_name REORGANIZE [SIZE target_size];
The target_size value determines the cutoff threshold for objects to be reorganized. The system attempts to combine all storage objects of the given size or smaller into larger objects, up to the maximum size allowed by an Object File System.
For more information about the ALTER TABLE syntax, see ALTER TABLE.
For more information about the ALTER TABLE REORGANIZE syntax, see ALTER TABLE REORGANIZE.