Overview
default_skip_index_level specifies the default value of skip_index_level for creating tables in a tenant.
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 | INT |
| Default Value | 0 |
| Value range |
|
| Modifiable | Yes, you can use the following methods:ALTER SYSTEM SETStatement modification. |
| Whether to restart the OBServer node for the change to take effect | No, the setting takes effect immediately. |
Usage instructions
The default_skip_index_level parameter only affects the default format for creating primary tables in user tenants. It does not affect the meta or sys tenant. Additionally, it only takes effect when the skip_index_level clause is not explicitly specified in the table creation statement. If the user explicitly specifies the table's skip_index_level, the final table's skip_index_level will be parsed according to the user-specified format.
This parameter can be set to the following values:
- 1: If skip_index_level is not specified in the table creation statement, the skip_index_level for creating a table by a user tenant is set to 1.
- 0: If skip_index_level is not specified in the table creation statement, the skip_index_level for creating a table by a user tenant is 0.
Modifying the value of this parameter does not affect tables that have already been created.
Configuration example
The default value of skip_index_level for creating tables in a user tenant is set to 1.
obclient> ALTER SYSTEM SET default_skip_index_level = 1;