Automated Foreground Merge

The IQ server will automatically perform a blocking (foreground) merge when necessary.

Certain actions require an automatic blocking merge before the action can commence:

Accessing a table at table-level snapshot isolation (rather than row-level snapshot isolation)
RLV DML approaching RLV memory limit
Using DDL commands such as CREATE or ALTER.

Commands which require an immediate automatic blocking merge may experience a pause while the merge is executed, before the command proceeds.