Update causing view to update indexes, which means incredibly slow updates.
I am running a sproc to update a single row in a table. This table is referenced by a view, which forces an index seek on all tables referenced by the view. Up until recently, it was running pretty fast. Now it has slowed to ~5 minutes.
Is this normal behavior? How can I optimize this situation?
Has the view that is being referenced always been an indexed view? Perhaps it wasn't and now it is and that is why the performance changed suddenly.