MySQL Forums
Forum List  »  InnoDB

Re: Whether Multiple index on Single table is necessary!??
Posted by: Peter Brawley
Date: October 21, 2015 11:18AM

To find what indexes you need, run Explain Extended on your big-data queries and add/adjust indices till all clauses with significant counts are adequately indexed and the query performs well.

It must be said, though, that columns col1, ...col60 strongly suggest the table isn't normalised and may therefore not perform well.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Whether Multiple index on Single table is necessary!??
869
October 21, 2015 11:18AM


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.