LOAD INDEX INTO CACHE tbl_index_list [, tbl_index_list] ... tbl_index_list: tbl_name [[INDEX|KEY] (index_name[, index_name] ...)] [IGNORE LEAVES]
The LOAD INDEX INTO CACHE
statement preloads a table index into the key cache to which it has been assigned by an explicit CACHE INDEX
statement, or into the default key cache otherwise. LOAD INDEX INTO CACHE
is used only for MyISAM or Aria tables. Until MariaDB 5.3, it was not supported for tables having user-defined partitioning, but this limitation was removed in MariaDB 5.5.
The IGNORE LEAVES
modifier causes only blocks for the nonleaf nodes of the index to be preloaded.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/load-index/