Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of Cache Index Mysql statement

Example of Cache Index Mysql Statement:

CACHE INDEX t1 IN non_existent_cache;
CACHE INDEX t1, t2, t3 IN hot_cache;

Example of Mysql Cache Index


CACHE INDEX
tbl_index_list [, tbl_index_list] ...
IN key_cache_name

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