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
PARTITION BY RANGE(TO_DAYS(EventTime))
and then plan on dealing with a sliding set of partitions. This necessitates doing DROP PARTITION and REORGANIZE PARTITION. More details:
http://mysql.rjweb.org/doc.php/partitionmaint
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.)
Subject
Views
Written By
Posted
3040
November 06, 2016 11:22PM
Re: Query to a partitioned table using all partitions
1499
November 12, 2016 05:55PM
1265
November 18, 2016 03:16AM
1285
November 19, 2016 03:42PM
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.