MySQL Forums
Forum List  »  Partitioning

Re: (non-unique) index more efficient than partition pruning
Posted by: Rick James
Date: November 19, 2014 06:01PM

Here's some of what we have have discussed, plus more. In particular it includes the two SQLs that I promised you a few days ago.
http://mysql.rjweb.org/doc.php/staging_table
Please review it and let me know of any typos, goofs, missing things, wrong statements, whatever.

Was that partition pruning issue with MariaDB 5.2? There may have been improvements since then.

> partitions = idx0,idx2

That is an issue with 'bad' dates mapping to the 'first' partition. Hence it is better to have the first partition empty (bogus).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: (non-unique) index more efficient than partition pruning
1084
November 19, 2014 06:01PM


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.