Note
- For V4.6.x, this parameter is available starting with V4.6.0.
- For V4.3.5, this parameter is available starting with V4.3.5 BP5.
- For V4.4.x, this parameter is available starting with V4.4.2.
Description
default_skip_index_level specifies the default value of skip_index_level when a table is created in a tenant.
Privilege requirements
Query the parameter
The
systenant and all user tenants can use theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | INT |
| Default value | 0 |
| Value range |
|
| 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. |
Considerations
The default_skip_index_level parameter only affects the default format for creating primary tables in user tenants. The meta and sys tenants are not affected. The parameter only takes effect when the skip_index_level option is not explicitly specified in the CREATE TABLE statement. If the skip_index_level option is explicitly specified, the final skip_index_level of the table is determined by the specified value.
You can set this parameter to the following values:
- 1: If the
skip_index_leveloption is not explicitly specified in the CREATE TABLE statement, theskip_index_levelof the table created by the user tenant is 1. - 0: If the
skip_index_leveloption is not explicitly specified in the CREATE TABLE statement, theskip_index_levelof the table created by the user tenant is 0.
Changing the value of this parameter does not affect tables that have already been created.
Examples
MySQL mode: Set the default value of
skip_index_levelfor creating tables in the user tenant to 1.obclient> ALTER SYSTEM SET default_skip_index_level = 1;Oracle mode: Set the default value of
skip_index_levelfor creating tables in the user tenant to 1.obclient> ALTER SYSTEM SET "default_skip_index_level" = 1;