MySQL, Query, Optimization, Web Performance, Database.
index optimization methods: 1, using the index keyword as a condition for the connection 2, the use of composite index 3, index merge or and, the fields involved are merged into a composite index 4, where, and group by involve field indexing 6. Sub-query optimization In the from is a non-correlated