MySQL Forums
Forum List  »  Optimizer & Parser

Re: sql_no_cache added by the optimizer
Posted by: KimSeong Loh
Date: March 08, 2007 07:19PM

SQL_NO_CACHE is to prevent the query to be cached by the query cache, since you use the CUURENT_DATE(), the result cannot be cached and resued, therefore it will not be cached in the query cache.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: sql_no_cache added by the optimizer
2030
March 08, 2007 07:19PM


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.