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.