MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Mystified by Partition Pruning on Dates
Posted by: Rick James
Date: May 20, 2010 07:58AM

In the second case, change
WHERE col2 = DATE('2010-02-02');
to
WHERE col2 = '2010-02-02;
MySQL does not optimize functions.

I see that you did that on the first one; I can't explain it.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Mystified by Partition Pruning on Dates
2971
John Thompson
May 19, 2010 03:45AM
Re: Mystified by Partition Pruning on Dates
1722
Rick James
May 20, 2010 07:58AM
Re: Mystified by Partition Pruning on Dates
1868
John Thompson
May 20, 2010 08:35AM


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.