MySQL Forums
Forum List  »  Partitioning

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

Written By
April 12, 2012 06:28AM
Re: key partition
April 13, 2012 08:16AM
April 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.