Configure RLV Storage on Tables

A table enabled for RLV storage has two parts: one residing on the IQ main store, and the other residing on the dedicated in-memory RLV Column Store.

You can have tables enabled for row-level versioning storage coexisting on the same database with other tables having table-level versioning storage.

Row-level versioning of global and local temporary tables is not supported.

• Creating a New Table with RLV Storage Settings
  When creating a new base table, you can specifically enable or disable RLV storage.
• Enabling or Disabling RLV Settings for an Existing Table
  You can alter an existing base table so that it is enabled or disabled for RLV storage.
• Configuring Default Storage for Tables
  When the {ENABLE | DISABLE} RLV STORE clause of the CREATE TABLE statement is not present, the BASE_TABLES_IN_RLV_STORE option setting is used to determine RLV storage. Thus, you can allow existing CREATE TABLE statements to run without modifying scripts to enable RLV storage.