Yet we keep praying at its altars. Delta are just playing the game. It might not be the nicest thing to do, but it is honest at least. All entrepreneurs are pounding their collective fists on their skulls to think of ways to extract as much value from the market as possible. Let's blame the game instead of the players.
My assumption is that people have used orms that automatically add the index for you when you create a relationship so they just conflate them all. Often they’ll say that a foreign key is needed to improve the performance and when you dig into it, their mental model is all wrong. The sense they have is that the other table gets some sort of relationship array structure to make lookups fast.
It’s an interesting phenomenon of the abstraction.
Don’t get me wrong, I love sqlalchemy and alembic but probably because I understand what’s happening underneath so I know the right way to hold it so things are efficient and migrations are safe.