LOAD INDEX INTO CACHE

Purpose

You can use this statement to load indexes to a cache to improve the query performance. You can load multiple indexes at a time, instead of loading them one by one. This can reduce the system overhead in loading indexes, thereby improving the overall performance.

Syntax

LOAD INDEX INTO CACHE tbl_index_list [, tbl_index_list ...];

tbl_index_list:
    tbl_name [PARTITION (partition_list)] [{INDEX|KEY} (index_name[, index_name ...])] [IGNORE LEAVES]

partition_list:
    partition_name [, partition_name ...]
    | ALL