MySQL Forums
Forum List  »  Partitioning

Partition pruning tip: Use comparisons of column, not partitioning function value
Posted by: Edwin DeSouza
Date: May 27, 2007 09:36AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Partition pruning tip: Use comparisons of column, not partitioning function value
3138
May 27, 2007 09:36AM


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.