GROUP BY DAYOFMONTH slow

[Eric Jain]

The following query runs unexpectedly slow (~30s, whereas MySQL/MyISAM
runs the same query in in less than 5s):

  SELECT DAYOFMONTH(t) AS d, COUNT(*) AS total
  FROM requests
  GROUP BY DAYOFMONTH(t)
  ORDER BY d;

Any suggestions?

Also, why can I not say 'GROUP BY t'?

--
Eric Jain


-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]