---
title: "#indexing-strategy articles | Hashnode"
description: "Explore 4 articles tagged #indexing-strategy on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/indexing-strategy"
---

Tag

# #indexing-strategy

4 posts · 0 followers

[Kevin gakio](https://hashnode.com/@kevin1146) · [Oct 12](https://hashnode.com/posts/one-index-64-faster-what-a-composite-index-actually-does/6acd21d2c8dd9b1bef876d43)

### [One index, 64× faster: what a composite index actually does](https://kevingakio.hashnode.dev/one-index-64-faster-what-a-composite-index-actually-does?utm_source=hashnode&utm_medium=feed)

A query summing one customer's payments took 1,086 ms. After adding one index, the same query took 17 ms. The query didn't change. What changed was how MySQL could find the rows. Here's what happened

5 min read · [kevingakio.hashnode.dev](https://kevingakio.hashnode.dev/one-index-64-faster-what-a-composite-index-actually-does?utm_source=hashnode&utm_medium=feed)

[Lakshay Gupta](https://hashnode.com/@voidness) · [Dec 31, 2025](https://hashnode.com/posts/read-this-before-creating-your-next-index-in-psql/6954732586c4c7189f491aca)

### [Read this Before Creating Your Next Index in PSQL](https://blog.lakshyabuilds.com/read-this-before-creating-your-next-index-in-psql?utm_source=hashnode&utm_medium=feed)

If you are a beginner in your developer journey tasked with optimizing a database query, you must have read about applying indexes. But not all indexes bring performance gains. Some can even degrade it. Read this blog before your create your next ind...

8 min read · [blog.lakshyabuilds.com](https://blog.lakshyabuilds.com/read-this-before-creating-your-next-index-in-psql?utm_source=hashnode&utm_medium=feed)

[krishna chaitanya](https://hashnode.com/@krishnavulchi) · [Dec 23, 2025](https://hashnode.com/posts/postgres-optimization-23s-to-1ms/694ad610bd0a6569de3ed8ae)

### [𝐅𝐫𝐨𝐦 23 𝐒𝐞𝐜𝐨𝐧𝐝𝐬 𝐭𝐨 1.3 𝐌𝐢𝐥𝐥𝐢𝐬𝐞𝐜𝐨𝐧𝐝𝐬: 𝐀 𝐃𝐚𝐭𝐚𝐛𝐚𝐬𝐞 𝐃𝐞𝐭𝐞𝐜𝐭𝐢𝐯𝐞 𝐒𝐭𝐨𝐫𝐲(𝐋𝐞𝐚𝐫𝐧𝐢𝐧𝐠 𝐏𝐫𝐨𝐣𝐞𝐜𝐭)](https://krishnavulchi.com/postgres-optimization-23s-to-1ms?utm_source=hashnode&utm_medium=feed)

(Or: How I learned to stop worrying and love the Query Plan) I built a URL Shortener. It was simple. It was elegant. It worked perfectly on my laptop with 50 rows of data. Then, I loaded 100,000 rows of historical data to simulate a real production e...

4 min read · [krishnavulchi.com](https://krishnavulchi.com/postgres-optimization-23s-to-1ms?utm_source=hashnode&utm_medium=feed)

[Ashifur Rahaman](https://hashnode.com/@ashif-arsb) · [Dec 4, 2025](https://hashnode.com/posts/sql-server-indexing-a-comprehensive-strategy-guide/6931832ce3b5d3a211c84560)

### [SQL Server Indexing: A Comprehensive Strategy Guide](https://sqlinsights.hashnode.dev/sql-server-indexing-a-comprehensive-strategy-guide?utm_source=hashnode&utm_medium=feed)

In the world of databases, indexing is the single most impactful factor in performance. A well-indexed database can handle millions of requests seamlessly; a poorly indexed one will choke on a few thousand. This guide covers the architecture, strateg...

5 min read · [sqlinsights.hashnode.dev](https://sqlinsights.hashnode.dev/sql-server-indexing-a-comprehensive-strategy-guide?utm_source=hashnode&utm_medium=feed)
