On 28 Aug 2009, at 21:13, Steven Lembark wrote:
> If I query on foo_id % 8, explain shows the optimizer
> using the constraint (1).
>
> If I just query on foo_id = 100, the exclusion is
> not used (2).
>
> What would be the best way to feed the optimizer
> enough data to use the partitioning with equality
> queries?
What about foo_id = 100 AND foo_id % 8 = 100 % 8 ?
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.
!DSPAM:737,4a9911a711861381017743!