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

Hi,

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(t1.date) FROM epi_flash_meas t1 JOIN epi_wafer t2 USING (wafer_name) GROUP BY wafer_name ORDER BY t1.date DESC LIMIT 0,30;

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2752
August 14, 2012 01:06PM
Re: Query with GROUP BY not using Index
1285
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.