MySQL Forums
Forum List  »  Optimizer & Parser

Re: Explain estimate completely wrong for range when partitioned by day
Posted by: Mattias Jonsson
Date: February 14, 2014 09:44AM

Hi Blake,

Also include an optimizer trace would be useful:
http://dev.mysql.com/doc/internals/en/optimizer-tracing-typical-usage.html

I suggest you to report a bug on this, including CREATE TABLE, data generation script and the affected query and post the bug number here.

With that info it is easier for us to debug and find a solution for you.


Regards
Mattias Jonsson, MySQL Partitioning developer.

Options: ReplyQuote




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.