Purpose
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.
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
Note
The syntax of this statement is supported in the current version, but the functionality is not effective.