MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Query with GROUP BY not using Index
2963
Imran Akbar
August 14, 2012 01:06PM
Re: Query with GROUP BY not using Index
1445
Øystein Grøvlen
August 15, 2012 02:46AM
Re: Query with GROUP BY not using Index
1352
Imran Akbar
August 16, 2012 10:30AM
Re: Query with GROUP BY not using Index
1623
Øystein Grøvlen
August 17, 2012 02:58AM
Re: Query with GROUP BY not using Index
1352
Rick James
August 18, 2012 10:30PM
Re: Query with GROUP BY not using Index
1314
Imran Akbar
August 24, 2012 12:41PM
Re: Query with GROUP BY not using Index
1374
Øystein Grøvlen
August 28, 2012 03:11AM
Re: Query with GROUP BY not using Index
1444
Imran Akbar
August 28, 2012 06:21PM
Re: Query with GROUP BY not using Index
1815
Øystein Grøvlen
August 29, 2012 01:28AM
Re: Query with GROUP BY not using Index
1268
Imran Akbar
August 29, 2012 10:36AM


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.