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 90 views

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

Thomas LaRock Aug 23, 2021 81 views

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

Thomas LaRock Aug 19, 2022 80 views