Updated on 2025-05-29 GMT+08:00

Creating an Index Online

delete_cctmp_table

Parameter description: Specifies whether to delete temporary tables generated during Ustore online index creation or rebuilding. This parameter can be set at the PDB level.

Parameter type: Boolean.

Unit: none

Value range:

  • on: indicates that the temporary tables are deleted.
  • off: indicates that the temporary tables are retained.

Default value: on. In the PDB scenario, if this parameter is not set, the global setting is inherited.

Setting method: This is a USERSET parameter. Set it based on instructions provided in Table 1.

Setting suggestion: This parameter is enabled by default. Set this parameter to off if you want to retain temporary tables generated during online index creation or rebuilding.

Risks and impacts of improper settings: Change the parameter value after fully understanding the parameter meaning and verifying it through testing.

enable_bypass_insert_sequence

Parameter description: Specifies whether SQL Bypass is supported when an INSERT statement of a table that contains auto-increment columns.

Parameter type: Boolean.

Unit: none

Value range:

  • on: SQL Bypass optimization is supported.
  • off: SQL Bypass optimization is not supported.

Default value: on

Setting method: This is a USERSET parameter. Set it based on instructions provided in Table 1.

Setting suggestion: This parameter is enabled by default. Set it to off if the INSERT statements containing auto-increment lists do not require SQL Bypass optimization.