Originally published at hafiz.dev





You added the index. You confirmed it's there with SHOW INDEX FROM orders. The query is still timing out in production, against the same created_at column you've had indexed for months.

This happens more than it should. MySQL's B-tree index is sitting right next to your query, completely ignored, and...