SolarWinds Blog

Inspecting Index Usage In MySQL, PostgreSQL, and MongoDB


Summary

02/08/19 In my recent post about the Left-Prefix Index Rule, I explained how queries can use all or part of a compound (multi-column) index. Knowing what makes an index fully usable by a query is important, but it’s also important to know how to figure ... The post Inspecting Index Usage In MySQL, PostgreSQL, and MongoDB 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 41 views

2
New Insights Into AI and Observability in Public Sector IT

SolarWinds Feb 20, 2025 39 views

3
5
The Secret Life of Accidental DBAs

SolarWinds Mar 28, 2025 35 views