← sources

At what point does database indexing become counterproductive?

source: reddit (reddit:database)published 2026-11-16 17:26ingested 2026-11-17 02:40

retained text

I've always thought of indexes as one of the first things to consider when improving query performance. But adding more indexes isn't always a good thing, especially when tables have frequent INSERT, UPDATE, and DELETE operations.

I'm curious how people decide which indexes are actually worth keeping.

Have you ever removed an index and noticed an improvement in overall database performance? Or found that an index was doing more harm than good?

Would be interesting to hear some real-world experiences.

document fetched 2026-11-17 00:38 · canonical https://reddit.com/r/Database/comments/1xxve4w/at_what_point_does_database_indexing_become