No much we can do with the update statement since it joins to a view. We would need to see the DDL for the view and the underlying tables (including indexes).