5 and i want to identify missing indexes in it. Can somebody please help me to identify ? This will help us to increase the performance of query that leads to application.
Asked
Active
Viewed 2.5k times
7
-
You mean that you want to find the tables which do not have indexes? – Rahul Tripathi Jun 03 '15 at 17:30
-
nope not like that, if i am executing particular query and if it is missing some column in indexes which can leads to faster execution of query after adding/including that column in index or the query executing without indexes. – Vikrant More Jun 03 '15 at 17:34
-
In SQL Server in execution plan query optimizer suggest the missing index and its percent of increase in executing the query kind of looking in MySQL. – Vikrant More Jun 03 '15 at 17:35
-
1Related: http://dba.stackexchange.com/questions/40407/mysql-logging-queries-which-would-execute-without-using-indexes – iamkrillin Jun 03 '15 at 17:37
1 Answers
9
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:
Community
- 1
- 1
Rahul Tripathi
- 168,305
- 31
- 280
- 331
-
1Note: Workbench has Visual Explain built-in, so also consider checking that. – Philip Olson Jun 03 '15 at 18:59