MySQL Forums
Forum List  »  Optimizer & Parser

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

Huh, in fact it is like that:

SELECT recepti.ID, recepti.ImeRecepta, recepti.Datum, receptislike.ID AS IDslike
FROM recepti
LEFT JOIN receptislike ON recepti.ID = receptislike.IDrecept
WHERE slovnica = 1 and validirano = 1 and datum < date() and jezik=1
GROUP BY recepti.ID
ORDER BY recepti.Datum DESC

Datum means date in my language :-)

Here is the explain:

id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE recepti ref recepti_multi recepti_multi 2 const 2974 Using where; Using temporary; Using filesort
1 SIMPLE receptislike ref receptislike_idx receptislike_idx 4 kulinarika.recepti.ID 1

Here is the recepti_multi index:

recepti_multi INDEX 5947 slovnica
Datum
jezik
Kategorija
Validirano

Options: ReplyQuote


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


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.