These examples demonstrate how to use ALTER TABLE requests to modify the merge block ratio setting for an individual table.
The first example changes the default merge block ratio for emp_table so that the system retrieves the current value for the DBS Control parameter MergeBlockRatio and applies this value when merging smaller data blocks into a larger data block.
ALTER TABLE emp_table, DEFAULT MERGEBLOCKRATIO;
The next example modifies the current setting of the merge block ratio for emp_table to 25%.
ALTER TABLE emp_table, MERGEBLOCKRATIO = 25 PERCENT;
The final example disables all data block merging for emp_table.
ALTER TABLE emp_table, NO MERGEBLOCKRATIO;