No matter what I do, I cannot get this query NOT to use filesort/tmp table.
SELECT … FROM messages WHERE author=1 AND flag=0 GROUP BY checksum, recipient ORDER BY timestamp DESC LIMIT 10;
Is it possible to get this query to use INDEX/WHERE only?
The index is on:
INDEX(author, flag, checksum, recipient, timestamp)