MySQL Forums
Forum List  »  General

Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
Posted by: tom worster
Date: December 29, 2010 03:51PM

Shawn Taylor Wrote:
-------------------------------------------------------
> Tom,
>
> Exactly right.
>
>
> 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

Well, there we have it. Thanks Shawn.

If you're a StackOverflow user, copy and paste that answer to http://stackoverflow.com/questions/4528325 and I'll accept it.

Options: ReplyQuote


Subject
Written By
Posted
Re: “CACHE INDEX” and “LOAD INDEX INTO CACHE”
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.