>> SELECT id_team,
>> sum(IF(m.id_visitor = t.id_team,m.visitor_score,
>> m.home_score)) AS But_pour,
>> sum(IF(m.id_visitor != t.id_team,m.visitor_score,
>> m.home_score)) AS But_contre
>> FROM tab_teams t, tab_matchs m
>> WHERE
> What is the best choice for my index on this query?
>
> SELECT id_team,
> sum(IF(m.id_visitor = t.id_team,m.visitor_score,
> m.home_score)) AS But_pour,
> sum(IF(m.id_visitor != t.id_team,m.visitor_score,
> m.home_score)) AS But_contre
>
What is the best choice for my index on this query?
SELECT id_team,
sum(IF(m.id_visitor = t.id_team,m.visitor_score,
m.home_score)) AS But_pour,
sum(IF(m.id_visitor != t.id_team,m.visitor_score,
m.home_score)) AS But_contre
FROM
