Skip navigation links

MySQL Forums :: Partitioning :: key partition


Advanced Search

Re: key partition
Posted by: Mattias Jonsson ()
Date: April 13, 2012 08:16AM

The performance depends on the usage.

if you only do lookups by partition key and it is not indexed, then it will be faster the more partitions you use, since it will scan a smaller piece of the table.

if you do not include the partition key it will be slower the more partitions you use, since you only adding overhead by partitioning without using the benefit of pruning.

Options: ReplyQuote


Subject Views Written By Posted
key partition 1253 jongse park 04/12/2012 06:28AM
Re: key partition 849 Mattias Jonsson 04/13/2012 08:16AM
Re: key partition 885 Rick James 04/13/2012 04:12PM


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.