MySQL Forums
Forum List  »  Partitioning

Re: Mystified by Partition Pruning on Dates
Posted by: John Thompson
Date: May 20, 2010 08:35AM

Thanks Rick - I actually put the function around it in desperation in case the optimiser was thinking it was a string and not a date. With or without the function, the outcome is the same. I'm still stumped :-(
If you run the same code do you get the same outcome, or does your DB prune as expected? If it prunes correctly then there is probably something about the way my DB is configured. If you get the same outcome as me then it could be the way I'm writing the DDL.

Options: ReplyQuote

Written By
Re: Mystified by Partition Pruning on Dates
May 20, 2010 08:35AM

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.