mam zapytanie:
SELECT c . * , g.gname, cat.password FROM games_champs AS c INNER JOIN games_list AS g ON c.champ_gid = g.gid INNER JOIN games_cats AS cat ON g.gcat = cat.c_id
gdzie
champ_gid PRIMARY
gid PRIMARY
gcat INDEX
c_id PRIMARY
explain wyrzuca:
Kod
1 SIMPLE cat system PRIMARY NULL NULL NULL 1
1 SIMPLE c ALL PRIMARY NULL NULL NULL 374
1 SIMPLE g eq_ref PRIMARY,gcat PRIMARY 4 gramy24_main.c.champ_gid 1 Using where
1 SIMPLE c ALL PRIMARY NULL NULL NULL 374
1 SIMPLE g eq_ref PRIMARY,gcat PRIMARY 4 gramy24_main.c.champ_gid 1 Using where
z tego co rozumiem zapytanie nie używa indeksów, dlaczego?