Find Queries That Lack Indexes
SolarWinds Blog

Find Queries That Lack Indexes


Summary

12/17/14 It’s an ancient tradition amongst MySQL DBAs to analyze slow query log files and sort the results by the so-called “index ratio” to find badly indexed queries. The “index ratio,” in this case, is a heuristic derived from the ratio of rows read to ... The post Find Queries That Lack Indexes appeared first on SolarWinds Blog.
Read the Original Article

This article originally appeared on SolarWinds Blog.

Read Full Article on Original Site

Related Articles

Popular from SolarWinds Blog

1
The Role of a Junior DBA: Challenges and Tools for Success

SolarWinds Mar 28, 2025 45 views

2
3
New Insights Into AI and Observability in Public Sector IT

SolarWinds Feb 20, 2025 40 views

5
The Secret Life of Accidental DBAs

SolarWinds Mar 28, 2025 39 views