TGViewer
CatOps CatOps @catops · 5.08K subscribers
Post #2928 1.44K
Not all index scans are equal is an article by Datadog, where they describe the idea of targeted DB indices and when to use those.

There is also some praise for their database monitoring tooling, but this is a vendor article after all.

The only thing is that they didn't mention that too many indices also comes with a price: you need to store and update them. So, always evaluate the performance for some period of time after adding indices.

#databases #observability
Datadog Not all index scans are equal: How we cut query latency by over 99% | Datadog Just because your query uses an index scan doesn’t mean it’s fast or performant. Learn how misaligned predicates and column order hurt index scan performance and how to detect this pattern using DBM.
  • 👍 2
  • 🔥 1
  • 👏 1
More from @catops
  1. Sep 29, 2026A Cybersecurity books bundle by O’Reilly on Humble Bundle. The bundle is fresh and is stil…
  2. Sep 28, 2026​​For today’s Donations Monday, I’d like to remind you about a fundraiser for a pickup tru…
  3. Sep 26, 2026Here’s Datadog’s take on the increased load on CI. In this article they explain how their…
  4. Sep 25, 2026A new chapter of the CatOps Digest is here! https://newsletter.catops.dev/p/catops-digest-…
  5. Sep 24, 2026Shopify wrote an article on them moving from React Native to the native code for their mob…
  6. Sep 23, 2026A bunch of practice exams on Humble Bundle, if you're into this type of thing. This offer…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →