From Dev.to
Telling apart 3 reasons MySQL isn't using your index
You are reading the slow query log in CloudWatch Logs or a similar tool, and one query has a Rows_examined (rows read) about equal to the table's row count, or larger, while its Rows_sent (rows return...