MySQL Forums
Forum List  »  Partitioning

Re: wrong output generate while using partitions
Posted by: Rick James
Date: December 14, 2014 10:33PM

What version are you running?

A compound index will perform better for the one query you showed us:
INDEX(column2, column3) or INDEX(column3, column2)

Are you getting any performance benefit with PARTITIONing?
Are you getting any other benefit?

Options: ReplyQuote

Written By
Re: wrong output generate while using partitions
December 14, 2014 10:33PM

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.