I did encounter this exact issue; and sure enough, the developers had no clue how to use indexes: "just slap an index on every column, and it will Magically Ju

I did encounter this exact issue; and sure enough, the developers had no clue how to use indexes: "just slap an index on every column, and it will Magically Just Work." In other words, even 10 indexes per table is a red flag; if you see more than 30 indexes on a table, something is terribly wrong - database architecture, programmers' understanding of how indexes work, or both.