Category "database-indexes"

MySQL is not using composite index with ORDER BY clause

I have a table user that looks like this id | first_name | last_name | org_id This table has few million entries. I want to run the below query with an exact