Updating a view in sql server 2016 relative rock dating methods
Even if an expression is deterministic, if it contains float expressions, the exact result may depend on the processor architecture or version of microcode.
To ensure data integrity, such expressions can participate only as non-key columns of indexed views.
you're not breaking the rules for updateable views, then you should be okay.
Typically, it does a good job with this, so the update view plan may look very similar to a plan for a simple update to the single affected base table. Then read this blog I wrote recently to see how it could be affected.
The View Designer is a visual tool that can help you build views.
Creating a unique clustered index on a view improves query performance because the view is stored in the database in the same way a table with a clustered index is stored.
The query optimizer may use indexed views to speed up the query execution.
The view does not have to be referenced in the query for the optimizer to consider that view for a substitution.
For example, the is not deterministic because it is always invoked with the same argument, but the value it returns changes each time it is executed.
To determine whether a view column is deterministic, use the Is Deterministic property of the COLUMNPROPERTY function.