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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot