Updated on 2024-06-03 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.

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

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.