MySQL Forums
Forum List  »  Partitioning

Advanced Search
New Topic

Re: Query problem with date partitioning
Posted by: Mac Soileau
Date: May 23, 2008 06:42AM

Sorry, I posted the wrong second query. The answer you gave makes perfect sense for the query I posted.

explain partitions select localDateTime from t1 where localDateTime between '2008-05-22 00:00:00' and '2008-05-22 23:59:59'
1, 'SIMPLE', 't1', 'p0,p1,p2,p3,p4,p5,p6,p7,p8,p9,p10,p11,p12,p13,p14,p15,p16', 'index', '', 'PRIMARY', '8', '', 320406613, 'Using where; Using index'

In this example, the optimizer should be able to narrow down the partitions based on the date range in the select right?

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


Subject
Views
Written By
Posted
Query problem with date partitioning
4342
Mac Soileau
May 22, 2008 04:39PM
Re: Query problem with date partitioning
2851
Phil Hildebrand
May 22, 2008 09:08PM
Re: Query problem with date partitioning
2806
Mac Soileau
May 23, 2008 06:42AM
Re: Query problem with date partitioning
3422
Phil Hildebrand
May 23, 2008 11:44AM
Re: Query problem with date partitioning
2523
Mattias Jonsson
May 23, 2008 02:35PM


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.