Purpose
You can use this statement to load the indexes on a specific database table to a cache to improve the query performance. This way, queries can access data more quickly based on cached indexes, thereby accelerating 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
In the current version, only the statement syntax is supported. The functionality does not actually take effect.