MySQL Forums
Forum List  »  Optimizer & Parser

Re: Make optimized LEFT JOIN with GROUP BY
Posted by: Jerry Potokar
Date: May 03, 2006 09:21AM

I tried adding recepti.ID to the multi index, but doesn't help.

But as sson as I use GROUP BY recepti.datum instead of recepti.ID it uses where and the query is 100x faster... I don't understand the logic but... I can also use group by recepti.datum, but if 2 recipes would have same datetime one will not show in the list so I prefer the ID.

Is there any way to say mysql I want only one data from table pictures? Then I wouldn't need to use group by...

It seems such a basic problem for me...



Edited 2 time(s). Last edit at 05/03/2006 10:30AM by Jerry Potokar.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Make optimized LEFT JOIN with GROUP BY
3675
May 03, 2006 09:21AM


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.