Example: Specifying MERGEBLOCKRATIO Settings - Teradata Vantage

For Object File System tables, MERGEBLOCKRATIO has a default setting that you cannot change.

This example sets the value of the merge block ratio for emp_table to 25%.

CREATE TABLE emp_table, MERGEBLOCKRATIO=25 PERCENT (
emp_no INTEGER);

This example defines emp_table in a way that disables all data block merges.

CREATE TABLE emp_table, NO MERGEBLOCKRATIO (
emp_no INTEGER);