MySQL Forums :: Partitioning :: Pruning problem.

Advanced Search

Re: Pruning problem.
Posted by: Mattias Jonsson ()
Date: September 28, 2010 10:38AM

The problem here is that you use a range, which HASH/KEY partitioning does not support pruning on (only RANGE/LIST does, as you can see on the partition level).

So I would suggest to partition BY RANGE (TO_DAYS(date_ril)).

Also note that invalid dates will be placed in the first partition (since TO_DAYS('2000-02-31') is NULL), so that partition will be searched too, so also add a 'dummy' partition as the first partition to catch these rows.

Options: ReplyQuote

Subject Views Written By Posted
Pruning problem. 2192 Vladimiro Puggelli 09/21/2010 04:03AM
Re: Pruning problem. 1121 Rick James 09/22/2010 07:57PM
Re: Pruning problem. 1198 Vladimiro Puggelli 09/23/2010 03:16AM
Re: Pruning problem. 1142 Rick James 09/23/2010 08:40AM
Re: Pruning problem. 1072 Vladimiro Puggelli 09/24/2010 02:24AM
Re: Pruning problem. 1215 Mattias Jonsson 09/28/2010 10:38AM

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.