default_skip_index_level

Description

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

Privilege requirements

• 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.

Attributes

Considerations

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 in columns that are included in the baseline SSTables. This option applies only to tables where merge_engine = 'delete_insert'.

Examples

• In MySQL mode: Set the default value of the skip_index_level parameter for tables created in a user tenant to 1.

  obclient> ALTER SYSTEM SET default_skip_index_level = 1;
  

• In Oracle mode: Set the default value of the skip_index_level parameter for tables created in a user tenant to 1.

  obclient> ALTER SYSTEM SET "default_skip_index_level" = 1;