MySQL Forums
Forum List  »  Optimizer & Parser

Re: Select last row that is less than or equal to a date
Posted by: Rick James
Date: February 03, 2013 02:59PM

This is a bit complex, but might confirm your theory... Turn on the "general log", run the query in MySQL Query Browser, then see what query was actually performed. Perhaps it reformulated it in some way that lost the optimization?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Select last row that is less than or equal to a date
1567
February 03, 2013 02:59PM


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.