MySQL Forums
Forum List  »  Optimizer & Parser

Re: Query with GROUP BY not using Index
Posted by: Øystein Grøvlen
Date: August 28, 2012 03:11AM


Yes, GROUP BY will implicitly order on the GROUP BY columns.

I think your query could be simplified as follows:

SELECT t1.wafer_name, MIN( FROM epi_flash_meas t1 JOIN epi_wafer t2 USING (wafer_name) GROUP BY wafer_name ORDER BY DESC LIMIT 0,30;

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

Options: ReplyQuote

Written By
August 14, 2012 01:06PM
Re: Query with GROUP BY not using Index
August 28, 2012 03:11AM

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.