Largely agree with this take, it often becomes "add an index because query might be slow" without much discussion or trade offs around query patterns. There's a

Largely agree with this take, it often becomes "add an index because query might be slow" without much discussion or trade offs around query patterns. There's a lot of "what if" over engineering that happens where you end up in hypothetical scenarios. Look at your real world use cases, query patterns and think hard about it.