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

3
Best Freshworks Competitors and Alternatives in 2026
Best Freshworks Competitors and Alternatives in 2026

Simon Abrahams Mar 13, 2026 158 views

4
5
The Secret Life of Accidental DBAs

SolarWinds Mar 28, 2025 140 views