How to optimize SQL query with ORDER BY?

Question

MySQL

When using ORDER BY to sort by date, the query execution increases by 10 times.

SELECT * FROM comments c INNER JOIN users u ON c.login = u.login ORDER BY c.date DESC LIMIT 5

Maybe I'm using ORDER BY somehow wrong.

Answer 1

indexes on both tables on login , then play with composite index login + date or just date