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

2
Automation Strategies to Help Hit Your SLAs

RJ Gazarek Feb 27, 2025 85 views

3
4
The Parallax View [of Your IT Career]
The Parallax View [of Your IT Career]

Thomas LaRock Aug 23, 2021 79 views

5
Let’s Recognize Awesome IT Pros for IT Pro Day 2022

Thomas LaRock Aug 19, 2022 77 views