MySQL Forums
Forum List  »  Partitioning

Re: Exceptions with Partition Pruning
Posted by: Rick James
Date: June 16, 2010 09:31AM

"The observed performance with that use case will be inferior than having regular index on a normal table." -- That will depend on the SELECT and the index(es); please show both.

"2000 Parameters" -- What is the distribution? If your example is any indication, those parameters hit about 1/4 of the partitions. Is this typical? What are the indexes and partition key?

Options: ReplyQuote

Written By
Re: Exceptions with Partition Pruning
June 16, 2010 09:31AM

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.