I'm a .NET developer. So, I know enough about databases to be dangerous, but do not have the expertise of a proper DBA.
We have a slow running stored proc and one of the devs here ran a query optimization tool which suggested the addition of some indexes.
It suggested 9 Non-clustered indexes and 78 statistics.
I know this is a pretty huge area and I know enough to know that I don't know much. So, given that I don't have access to a proper DBA to review the indexes and statistics, would it be a reckless move to just proceed with those suggested changes?
Rewriting the Stored Proc is another option we are not too keen on, as it is returning the correct data right now and we are reticent to mess with that.
But if there is a big gotcha that I am unaware of, I'd really like to find out about it. So, advice would be greatly appreciated.
I was going to post the most expensive query plan of the batch to Pastetheplan.com . Alas, I was unable to get permission from my manager. I can't see how a bit of random SQL will have any security implications etc., but the business is more paranoid than me. I realise this would have helped a lot and am disappointed I cannot post to it. The 1 index I added has helped a lot and the advice here has been much appreciated. Choosing an answer is tough and I'm still working on that.