CACHE INDEX

Description

This statement is used to load the indexes of a specific database table into the cache to improve query performance. Once the indexes are loaded into the cache, queries can access the index data more quickly, thereby accelerating query performance.

info

The current version only supports the syntax of this statement, but the functionality does not take effect.

Syntax

CACHE INDEX {
    tbl_index_list [, tbl_index_list ...]
    | tbl_name PARTITION (partition_list)
    }
    IN key_cache_name;

tbl_index_list:
    tbl_name [{INDEX|KEY} (index_name[, index_name ...])]

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