I'm working with a database that has some performance prolems. We have determined that some indexes need to be implemented to improve this.
I have the indexes scripted and I'm ready to apply them. I'm doing them in groups, not all at once, just in case...
My question is, are there any best practices for implementing these? Should I reindex before/after? Update Stats? etc?