Re: is it good add 3 index on a table with 30,000 insert in every 15 minutes?
Posted by: Rick James
Date: December 02, 2013 09:30PM

> Actually I have queries using this index in group by clause thats why i chose this. Is it correct move or wrong? because I can see in explain only query with hour in "where" is using this index.

Let's see the query.

MySQL will almost never use two indexes in one SELECT.

It will rarely use an index relating to the GROUP BY when filtering (WHERE) can use an index.

Options: ReplyQuote


Subject
Written By
Posted
Re: is it good add 3 index on a table with 30,000 insert in every 15 minutes?
December 02, 2013 09:30PM


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.