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.