Tags » Can't Tell

Does MySQL database optimize joins itself or do we have to specify the order to join?

I have a query like the following

select f.number,SUM(ii.qty),SUM(c.g1),SUM(c.g2),SUM(c.g3),SUM(c.g4),SUM(c.g5),SUM(c.g6)  from 
farmer as f 
    inner join 
        issue as i on f.number = i.farmerno 
            inner join 
                item_issue as ii on i.recno = (ii.recno+0)
                    inner join 
                        crop as c on c.farmerno = f.number
where ii.item like 'S%' 
group by f.number
… 40 more words
Recent Questions - Stack Overflow

Does MySQL database optimize joins itself or do we have to specify the order to join?

I have a query like the following

select f.number,SUM(ii.qty),SUM(c.g1),SUM(c.g2),SUM(c.g3),SUM(c.g4),SUM(c.g5),SUM(c.g6)  from 
farmer as f 
    inner join 
        issue as i on f.number = i.farmerno 
            inner join 
                item_issue as ii on i.recno = (ii.recno+0)
                    inner join 
                        crop as c on c.farmerno = f.number
where ii.item like 'S%' 
group by f.number
… 40 more words
Recent Questions - Stack Overflow

Need vs. Wants: I Can’t Tell

Hey everyone,
I’m coming to you from my mobile phone; this is so new to me even though I used Tumblr. on my phone but it wrote a blog post while sitting on my couch planning a date with the bae instead of in the office typing away on my computer is all new. 62 more words

Blog