MySQL Forums
Forum List  »  Partitioning

Accessing more partitions than needed
Posted by: dileep ch
Date: July 19, 2012 01:12AM

Hi,

I have column with date field and i partitioned using to_days function

PARTITION BY RANGE (to_days(cdate))
(PARTITION p0 VALUES LESS THAN (734928) ENGINE = InnoDB,
PARTITION p1 VALUES LESS THAN (734943) ENGINE = InnoDB,
PARTITION p2 VALUES LESS THAN (734959) ENGINE = InnoDB,
PARTITION p3 VALUES LESS THAN (734974) ENGINE = InnoDB
.....

Partition p0 means values less than '2012-03-01'
p1 less than '2012-03-16'
p2 less than '2012-04-01'
p3 less than '2012-04-16'
......

So when i'm select cdate between '2012-03-01' and '2012-03-31'

It was accessing p0,p1,p2
But i think it shouls access only p1 and p2 according partition purning.

And also accessing p0 when cdate>'2012-03-31'

What is the problem with this.

And can i partition in any other way with date column.

Options: ReplyQuote


Subject
Views
Written By
Posted
Accessing more partitions than needed
2194
July 19, 2012 01:12AM
1283
August 02, 2012 12:18AM
1177
August 02, 2012 02:44AM


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.