REFRESH INDEX

This command is used to merge all segments for data files in the secondary index table.

REFRESH INDEX indextable_name ON TABLE maintable_name
This command is used to merge all segments for which data files are to be merged.
REFRESH INDEX indextable_name ON TABLE maintable_name WHERE SEGMENT.ID IN (0,1,2..N)
This command is used to merge a batch of specified segments.

**Table 1** REFRESH INDEX parameters
Parameter	Description
indextable_name	Name of an index table
maintable_name	Name of the primary table

To clear the data file of compacted segments, run the CLEAN FILES command on the secondary index table.

REFRESH INDEX productNameIndexTable;

After this command is executed, the number of data files in the secondary index table will be reduced.

Parent topic: DDL

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.