如何在MySQL中找到缺失索引? [英] How to find Missing Indexes in MySQL?

问题描述

5，我想确定其中缺少的索引.有人可以帮我识别一下吗?这将有助于我们提高导致应用程序的查询的性能.

解决方案

我能想到的最好的方法是使用 MySQL执行计划是否取决于可用索引?

使用EXPLAIN编写更好的MySQL查询

解决方案

The best what I can think of is to use the EXPLAIN to check the execution plan of your query with index and without index and then see the difference in query performance.

You can also refer:

• Does MySQL exectution plan depend on available indexes?
• Using EXPLAIN to Write Better MySQL Queries
• How to find un-indexed queries in MySQL, without using the log

这篇关于如何在MySQL中找到缺失索引?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！