Can MySQL use multiple indexes for a single query?
Yes, MySQL can use multiple index for a single query. The optimizer will determine which indexes will benefit the query. You can use EXPLAIN to obtain information about how MySQL executes a statement. You can add or ignore indexes using hints like so: SELECT * FROM t1 USE INDEX (i1) IGNORE INDEX FOR ORDER BY … Read more