3 thoughts on “Be Careful When You Alter Indexed Views

  1. I like to put the index definition in a comment in the view definition. That way, if I have to alter the view for any reason, the index definition will be there in the comments so it will remind me to recreate the index.

Leave a Reply

Your email address will not be published. Required fields are marked *