Do I need to rebuild indexes on system databases? Even if I may not need to, should I?
My old maintenance plan included rebuilding indexes on the system databases (through the maintenance plan tasks). It was mostly set up that way because I didn't see anything that told me not to, and it was really easy to set up. It apparently doesn't break anything if you do, because it was running like that for a long time.
Now we have multiple servers and I'm scripting out my maintenance tasks. I found a really comprehensive script for rebuilding indexes, but it explicitly excluded all of the system databases. Should I modify it to run on system databases as well? If so, I'd probably make it a parameter so I can run it for user and system databases seperate (the way my old plan was built). Is it worth the effort?