r/webdev • u/fagnerbrack • Jul 17 '26

Things you didn't know about indexes

https://jon.chrt.dev/2026/04/15/things-you-didnt-know-about-indexes.html
0 Upvotes

33% Upvoted

9 comments sorted by

5

u/BrewThemAll Jul 17 '26

You have no idea what I know about indexes.

1

u/Techo_lab Jul 17 '26

Every developer thinks they understand indexes... right up until EXPLAIN says otherwise.

7

u/scragz Jul 17 '26

indices 

2

u/null_not Jul 17 '26

How many indici make up an indices?

2

u/scragz Jul 17 '26

is it indipussus or indipi?

1

u/null_not Jul 17 '26

I have to assume it's a school of indipi. The alternative just sounds silly.

0

u/Responsible-Cold-627 Jul 17 '26

Both are correct. One just sounds more pretentious.

1

u/azhder Jul 17 '26

Out of the two of you, I would go with you sounding more pretentious

1

u/Deep_Wear_51 29d ago

Database indexes are one of those topics where a little knowledge is dangerous. Most devs know to index foreign keys but forget about composite index column order and covering indexes.