Re: Partition Pruning

[Shawn Taylor]

My *guess* is that it is because you have a data range that spans both of them.

| partitioned_table | pt_201007      | 734350                | 2010-08-01 |          1 |
| partitioned_table | pt_201008      | 734381                | 2010-09-01 |          1 |

If your query looked like:

EXPLAIN PARTITIONS 
  SELECT COUNT(*) 
  FROM   partitioned_table
  WHERE  created_dtm >= '2010-08-01' 
  AND    created_dtm  < '2010-08-31';

It should only try to hit one.

Shawn