MySQL Forums
Forum List  »  Partitioning

Re: Partition pruning when partition expression contains a function
Posted by: Sandi Hubbard
Date: June 05, 2006 02:51PM

It would be so helpful if this particular information were provided in the manual as support is added. I've been scratching my head and searching the manual all afternoon trying to figure out why my DATEDIFF range partition EXPLAIN PARITIONS SELECTs want to scan all partitions. After reading this it is quite obvious why TO_DAYS would be a much more reliable choice, a mistyped partition on DATE_DIFF could really throw off the lineality.
Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Partition pruning when partition expression contains a function
2165
June 05, 2006 02:51PM


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.