---
title: "Discussion on \"From 9 Seconds to 2 Milliseconds: Database Indexes Explained\" | Hashnode"
description: "Discussion on \"From 9 Seconds to 2 Milliseconds: Database Indexes Explained\". How an index works, why it's a B-tree, and the one mistake that makes the database ignore it\n\n\nThis query took nine seconds:\nSELECT * FROM users WHERE email = 'priya@example.com';\n\nOne line of SQL mad"
url: "https://hashnode.com/posts/from-9-seconds-to-2-milliseconds-database-indexes-explained/6af72650653412673ab8d41f"
---

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

Discussion

# [From 9 Seconds to 2 Milliseconds: Database Indexes Explained](https://thebytemechanics.hashnode.dev/from-9-seconds-to-2-milliseconds-database-indexes-explained?utm_source=hashnode&utm_medium=feed)

How an index works, why it's a B-tree, and the one mistake that makes the database ignore it This query took nine seconds: SELECT \* FROM users WHERE email = 'priya@example.com'; One line of SQL mad

5d ago · 7 min read · thebytemechanics.hashnode.dev  
Updated 1d ago  
Read the article

## Written by

[The Byte Mechanics](https://hashnode.com/@thebytemechanics)

@thebytemechanics

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

How software works, under the hood ⚙️ Animated explainers on system design, backend and OS internals.

How software works, under the hood ⚙️ Animated explainers on system design, backend and OS internals. New deep dive every week, with a video on YouTube.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
