---
title: "Discussion on \"We Added the Index. The Query Was Still Slow. Here's Why\" | Hashnode"
description: "Discussion on \"We Added the Index. The Query Was Still Slow. Here's Why\". Added an index, query still slow? How composite indexes and the leftmost-prefix rule decide whether column order actually helps."
url: "https://hashnode.com/posts/we-added-the-index-the-query-was-still-slow-here-s-why/6ab219c0136985e17fc20dea"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [We Added the Index. The Query Was Still Slow. Here's Why](https://singh-technical-blog.hashnode.dev/we-added-the-index-the-query-was-still-slow-here-s-why?utm_source=hashnode&utm_medium=feed)

Added an index, query still slow? How composite indexes and the leftmost-prefix rule decide whether column order actually helps.

Sep 22 · 7 min read · singh-technical-blog.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#sqltutorial](https://hashnode.com/tag/sqltutorial)
-   [#technical-writing-1](https://hashnode.com/tag/technical-writing-1)

## Written by

[Harpreet Singh Kapula](https://hashnode.com/@happysingh89)

@happysingh89 · Hyderabad, India

  
[View profile](https://hashnode.com/@happysingh89)

## Responses

Markdown supported · ⌘↵ to post

No responses yet.