---
title: "Kevin gakio (@kevin1146) | Hashnode"
description: "Kevin gakio (@kevin1146) writes on Hashnode. Read their latest articles and follow their work."
url: "https://hashnode.com/@kevin1146"
---

@kevin1146

# Kevin gakio

@kevin1146 · Joined October 2026

### [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)

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