11.3.7 Redefining a range index (setting up chunk skipping)

To change the defined range index that cannot skip chunks into one that can skip chunks, redefine the range index, and then execute the adbidxrebuild command. The following shows the procedure.

1. Delete the range index.

   Use the DROP INDEX statement to delete the range index that cannot skip chunks. See 11.3.9 Deleting an index.

2. Redefine a range index.

   Use the CREATE INDEX statement to redefine a range index for the table for which the range index deleted in step 1 had been defined.

   For details about the CREATE INDEX statement, see CREATE INDEX (define an index) in Definition SQL in the manual HADB SQL Reference.

3. Rebuild a range index.

   Use the adbidxrebuild command to rebuild a range index for the table for which the range index was redefined in step 2.

   For details about the adbidxrebuild command, see adbidxrebuild (Rebuild Indexes) in the manual HADB Command Reference.

After the range index is redefined, executing the adbidxrebuild command creates a range index that can skip chunks.

To Page Top