Database Indexing

Comments discuss the trade-offs of using database indexes, including performance benefits for reads versus costs for writes, storage, memory, and maintenance.

📉 Falling 0.5x Databases
3,771
Comments
20
Years Active
5
Top Authors
#9425
Topic ID

Activity Over Time

2007
4
2008
19
2009
34
2010
84
2011
134
2012
168
2013
165
2014
123
2015
145
2016
181
2017
265
2018
183
2019
216
2020
193
2021
387
2022
385
2023
402
2024
328
2025
334
2026
21

Keywords

RAM CS e.g DB DBA DBMS pilosa.com sqlfordevs.com TLDR RQL index indexes indexing query db columns rows lookup table records

Sample Comments

abrookewood Aug 17, 2022 View on HN

If only we could add some indexes ...

mbrameld May 22, 2023 View on HN

I notice you didn't mention indexes...

jongs Dec 21, 2010 View on HN

Indexing is on but my understanding is that it only help reading, not writing on the DB

JodieBenitez Apr 24, 2024 View on HN

Love the idea ! But how ? It seems to be a costly indexing.

brianmcc Aug 28, 2023 View on HN

So... throw money on compute instead of just adding an index..?

petervandijck Oct 18, 2011 View on HN

Better a write with an index than a read without an index, my grannie always said.

sylware Apr 16, 2022 View on HN

because there is nothing creating bazillions of indexes in real time.

vlaaad Sep 17, 2018 View on HN

There are indexed attributes, isn't it a hope?

xcombelle May 8, 2016 View on HN

They mention that it's super fast without index. Is there a win with index ?

barrkel Oct 21, 2013 View on HN

Maintaining an index is a cost of the lookup efficiencies gained.