Overview
default_delta_format specifies the default incremental data storage format when a table is created.
Privilege requirements
Query parameters
Both the
systenant and all user tenants can query this parameter using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify parameters
Both the
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String |
| Default Value | flat |
| Value range |
|
| Modifiable | Yes, you can use theALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
You can modify the default_delta_format parameter to adjust the default incremental data format of a table, eliminating the need to specify it repeatedly during table creation:
flat: Fast write speed and low compression ratio, suitable for OLTP scenarios.encoding: The write speed is relatively slow, but the compression ratio is high. This mode can improve query performance in OLAP scenarios and reduce the storage space required for incremental data. It yields better query results when the table'sMERGE_ENGINEis set todelete_insert. For information about setting the table'sMERGE_ENGINE, see the Specify the table's update model section in Create a table.
Configuration example
Sets
encodingas the default incremental data format for tables created subsequently in the user tenant.obclient> ALTER SYSTEM SET default_delta_format = "encoding";Sets
flatas the default incremental data format for tables created subsequently in the user tenant.obclient> ALTER SYSTEM SET default_delta_format = "flat";