---
title: "You Don't Always Need Indexes"
url: https://daily.dev/posts/you-don-t-always-need-indexes-wdx2hyfdt
source_url: https://www.jefftk.com/p/you-dont-always-need-indexes
type: article
source: "Community Picks"
published: 2024-05-04T06:49:00.158Z
updated: 2025-09-06T02:40:36.195Z
tags: ["database", "full-text-search", "performance"]
reading_time: 2
upvotes: 7
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# You Don't Always Need Indexes

**[Community Picks](https://daily.dev/sources/community)** · 2 min read · 7 upvotes · 0 comments

## Summary

Consider adding indexing to your database only if you can't achieve acceptable performance with simple scans. Query-time work may be more efficient for rare and highly varied queries.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://www.jefftk.com/p/you-dont-always-need-indexes>

## Similar posts on daily.dev

- [Don’t just attend KubeCon \+ CloudNativeCon, Merge Forward your experience\!](https://daily.dev/posts/don-t-just-attend-kubecon-cloudnativecon-merge-forward-your-experience--l0rpp73x8) · CNCF · 0 upvotes · 0 comments
- [Announcing H2 2026 KCDs](https://daily.dev/posts/announcing-h2-2026-kcds-m96goajm1) · CNCF · 1 upvotes · 0 comments
- [Two months of Open Community Groups](https://daily.dev/posts/two-months-of-open-community-groups-asf52zhbs) · CNCF · 0 upvotes · 0 comments

---

Tags: [#database](https://daily.dev/tags/database), [#full-text-search](https://daily.dev/tags/full-text-search), [#performance](https://daily.dev/tags/performance)

[View this post on daily.dev](https://daily.dev/posts/you-don-t-always-need-indexes-wdx2hyfdt)