Last week, the developer asked me if it would be OK to add indexes to columns A,B,C,D,E,F,G,H, and I on TableA? I was a bit confused and asked him why? He said it would speed up the query so I asked to see the query. He said he didn't have it because EF created it, but indexes speed up queries right?

Seriously, I couldn't make that up. And this is the lead developer for the project.