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 automatically partitioned table, the global index is also automatically partitioned. If the primary table is not an automatically partitioned table, the global_index_auto_split_policy parameter determines whether to enable automatic partition splitting.

• If the global_index_auto_split_policy parameter is set to ALL, automatic partition splitting is enabled by default for newly created global indexes.

• If the global_index_auto_split_policy parameter is set to DISTRIBUTED, automatic partition splitting is enabled by default for newly created global indexes when multiple nodes are available in the tenant (for example, the number of primary zones or units in the tenant is greater than 1).

• If the global_index_auto_split_policy parameter 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 mode) or Automatic partition splitting (Oracle mode).

Examples

Enable automatic partition splitting for newly created global indexes.

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