79689215

Date: 2025-07-03 16:58:36
Score: 2.5
Natty:
Report link

Yes, you're on the right track — MySQL can only use an index for both filtering and sorting when the "ORDER BY" columns match the index's leftmost prefix and order.

Reasons:
  • Low length (1):
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (0.5):
Posted by: Abhishek