• If your index changes are not put into a script and attached to a change request, how can you put a database back to the same state if you later have to restore from an older backup?

    If  there is a complaint about performance later, you could go back through the latest changes to see if it all began when an index was created, dropped or modified.