I have literally never seen a single "competent software developer" who understands indexing or query optimization at all. All I see is spray and pray style in

I have literally never seen a single "competent software developer" who understands indexing or query optimization at all. All I see is spray and pray style indexing (create indexes semi-randomly until things seem fast enough).