MySQL Forums
Forum List  »  Optimizer & Parser

Re: Query with GROUP BY not using Index
Posted by: Øystein Grøvlen
Date: August 15, 2012 02:46AM

Hi,

I would guess the reason that an index is not picked is that you are indexing only a prefix of the wafer_name column. Try changing index definitions to

KEY wafer_name (wafer_name),
KEY wafer_name_date (wafer_name,date)

HTH,

Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway

Options: ReplyQuote


Subject
Views
Written By
Posted
2745
August 14, 2012 01:06PM
Re: Query with GROUP BY not using Index
1325
August 15, 2012 02:46AM


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.