I have an index on `food` and on `active`, how come the result of the
EXPLAIN doesn't show the query using an index? I'm concerned that as
the query time will grow with the table.
My Query:
SELECT `food` , COUNT( `food` ) AS 'population'
FROM `users`
WHERE `active`=1
GROUP BY `food`
LIMIT 0 , 25
Result of Explain:
id select_type table type possible_keys key key_len ref rows
Extra
1 SIMPLE users ALL active_idx NULL NULL NULL 11382 Using
where; Using temporary; Using filesort
-James
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
