Question
A composite index is `(tenant_id, created_at, status)`; which predicates can use its leftmost prefixes?
Answer
Use predicates beginning with `tenant_id`, optionally followed by `created_at` and `status`. Predicates starting with `created_at` or `status` do not gain ordinary leftmost-prefix lookup from this index. Build another index for that access path. Applies to MySQL and MariaDB.