Group By query optimization

[Kishore Jalleda]

Hi All,
          I have a mysql query which takes 8 seconds to run ona dual
xeon 2.4, 3Gig ram box,
SELECT gamename, MAX(score) AS score, COUNT(valid=1) AS played FROM
gamesessions AS gamesessions
                WHERE valid=1 AND sessiontype IN (1,2)
                GROUP BY gamename;
Explain select gives 

table   type    possible_keys   key     key_len         ref     rows    Extra
gamesessions    ALL     NULL    NULL    NULL    NULL    915522  Using where; 
Using
temporary; Using filesort

How can I optimize the query 
Thanks 
Kishore

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]