MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
Posted by: Shawn Taylor
Date: December 29, 2010 01:24PM

Tom,

Exactly right.

Quote
From The Manual
The syntax of CACHE INDEX enables you to specify that only particular indexes from a table should be assigned to the cache. The current implementation assigns all the table's indexes to the cache, so there is no reason to specify anything other than the table name.

http://dev.mysql.com/doc/refman/5.0/en/cache-index.html

Shawn

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
“CACHE INDEX” and “LOAD INDEX INTO CACHE”
tom worster
December 28, 2010 09:40AM
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
Shawn Taylor
December 28, 2010 03:23PM
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
Rick James
December 28, 2010 04:41PM
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
tom worster
December 29, 2010 10:42AM
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
Rick James
December 29, 2010 01:45PM
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
tom worster
December 29, 2010 10:52AM
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
Shawn Taylor
December 29, 2010 01:24PM
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
tom worster
December 29, 2010 03:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.