Purpose
This statement loads indexes of a specified database table into the cache to improve query performance. Once an index is loaded into the cache, queries can access the index data more quickly, which accelerates the queries.
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 feature is not enabled.