Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ Configuring GUC Parameters/ GUC Parameters/ Creating an Index Online
Updated on 2024-06-03 GMT+08:00
View PDF
Share

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.

Parent topic: GUC Parameters