global_index_auto_split_policy

Description

global_index_auto_split_policy specifies whether to enable automatic partition splitting for newly created global indexes.

Privilege requirements

• Query the parameter

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

• Modify the parameter

  The sys tenant and user tenants can use the ALTER SYSTEM SET statement to modify this parameter.

Attributes

Considerations

Use the ALTER SYSTEM SET statement to modify the value of the global_index_auto_split_policy parameter. If the primary table is an automatic partitioning table, the global index is automatically partitioned. If the primary table is not an automatic partitioning table, the global_index_auto_split_policy parameter determines the partitioning strategy.

• If the value of global_index_auto_split_policy is set to ALL, automatic partition splitting is enabled by default when a global index is created.

• If the value of global_index_auto_split_policy is set to DISTRIBUTED, automatic partition splitting is enabled by default when a global index is created, provided that the tenant has multiple nodes (such as more than one primary zone or more than one unit).

• If the value of global_index_auto_split_policy is set to OFF, automatic partition splitting is disabled for all global indexes, including existing ones.

For more information about automatic partition splitting, see Automatic partition splitting (MySQL-compatible mode) or Automatic partition splitting (Oracle-compatible mode).

Examples

Enable automatic partition splitting for a global index.

obclient> ALTER SYSTEM SET global_index_auto_split_policy = 'ALL';

References

For information about whether to enable automatic partition splitting for a tenant, see enable_auto_split