Utilizing multiple indexes per MySQL table join

• Ronald Bradford
• June 13, 2011

Historically it was considered that MySQL will generally use only one index per referenced table in a SQL query. In MySQL 5.0 the introduction of merge indexes enabled for certain conditions the possibility to utilize two indexes however this could result in worst performance then creating a better index.