MySQL Forums
Forum List  »  Optimizer & Parser

Re: Why Query Cache Actived Returns Wrong Results?
Posted by: Rick James
Date: September 24, 2012 11:43PM

Do you have an index on fecha1?
Do you have an index on clave?
I suspect you need indexes more than you need the QC.

I don't understand this syntax:
WHERE date fecha1<='201205'

Perhaps you meant
WHERE fecha1 < '2012-05-01'

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Why Query Cache Actived Returns Wrong Results?
1166
September 24, 2012 11:43PM


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.