I think you're conflating two different things here. I am not aware of any DB optimization articles that say "trust me bro, throw your data, don't build indice

I think you're conflating two different things here. I am not aware of any DB optimization articles that say "trust me bro, throw your data, don't build indices, it'll Just Work™!"