Heyho folks, Is there any chance that mySQL uses an index and not filesort if I do the following :
"select count(*)as cnt from table where ... group by id having cnt(*) > 2 order by cnt" The Problem here is the "order by" clause - everything else is easy and clear ( and fast ) but as soon as I apply the "order by" it uses filesort and slows down. I would be very happy about any hint ;) lars -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]