Example: Modifying MERGEBLOCKRATIO - Teradata Vantage

These examples demonstrate how to use ALTER TABLE requests to modify the merge block ratio setting for an individual table.

This example modifies the current setting of the merge block ratio for emp_table to 25%.

ALTER TABLE emp_table, MERGEBLOCKRATIO = 25 PERCENT;

This example disables all data block merging for emp_table.

ALTER TABLE emp_table, NO MERGEBLOCKRATIO;