Hi Harald, > Replacing the index on member_id by a compound index on (member_id, > id) might help.
Thank you very much for your suggestion. After replacing the index with compound index, the query works very fast now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
