Jeff Kaufman personal blog
Cases where full scans are better than indexes
Sometimes you have a lot of data, and one approach to support quick searches is pre-processing it to build an index so a search can involve only looking at a small fraction of the total data. The threshold at which it's worth switching to indexing, though, might be higher than you'd guess. Here are some cases I've…
- Points
- 243
- HN comments
- 214
- Submissions
- 1
- Cited by
- 0 commenters
Databases & DataSoftware Engineering2023
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| May 25, 2023 | Cases where full scans are better than indexes by xnx | 243 | 214 |
