default_skip_index_level

Last Updated:2026-09-03 07:31:11

Description

default_skip_index_level specifies the mechanism for generating Skip Indexes in incremental SSTables for a tenant.

Query the parameter

The sys tenant and all user tenants can query this parameter by using the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view.
Modify the parameter

The sys tenant and user tenants can modify this parameter.

Attribute	Description
Type	INT
Default value	0
Value range	0: Incremental SSTables do not generate Skip Indexes. 1: Incremental SSTables generate Skip Indexes for columns that have Skip Indexes in the baseline. This setting applies only to tables where `merge_engine = 'delete_insert'`.
Modifiable	Yes. You can use the `ALTER SYSTEM SET` statement to modify the parameter.
Effective upon OBServer node restart	No. The setting takes effect immediately.

The default_skip_index_level parameter only affects tables created in user tenants.

If default_skip_index_level = 0, incremental SSTables do not generate Skip Indexes.
If default_skip_index_level = 1, incremental SSTables generate Skip Indexes for columns that have Skip Indexes in the baseline. This setting applies only to tables where merge_engine = 'delete_insert'.

MySQL-compatible mode: Set the default value of the skip_index_level parameter for tables created in user tenants to 1. The following example shows how to do this in MySQL-compatible mode.
```
obclient> ALTER SYSTEM SET default_skip_index_level = 1;
```
Oracle-compatible mode: Set the default value of the skip_index_level parameter for tables created in user tenants to 1. The following example shows how to do this in Oracle-compatible mode.
```
obclient> ALTER SYSTEM SET "default_skip_index_level" = 1;
```

Previous topic

Next topic