Partition pruning tip: Use comparisons of column, not partitioning function value

[Edwin DeSouza]

Partition pruning tip: Use comparisons of column, not partitioning function value

A customer issue has drawn my attention to this this pecularity: if partitioning is done by the value of some function, then partition pruning module will make use of comparisons of the partitioning column(s), but not of comparisons of the value of the partitioning function. Here is an example:

http://s.petrunia.net/blog/?p=21