MySQL Forums
Forum List  »  Partitioning

Re: Query to a partitioned table using all partitions
Posted by: Rick James
Date: November 12, 2016 05:55PM

PARTITIONing has a lot of bells and whistles, most of them do not provide any performance benefit. You found one of them.

Instead, do
and then plan on dealing with a sliding set of partitions. This necessitates doing DROP PARTITION and REORGANIZE PARTITION. More details:

If you would like to show us the main queries, I will critique the indexes you have. (There can be subtle issues with indexing with partitioning.)

Options: ReplyQuote

Written By
Re: Query to a partitioned table using all partitions
November 12, 2016 05:55PM

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.