What can you do with indexed views?

indexed-views brent-ozar-unlimited

Post a Reply


What You Can (and Can’t) Do With Indexed Views 1 Security: we create views so that a user can read specific columns out of certain tables, but not all the data. 2 Simplification: sometimes, it’s easier to write a SELECT against one view than a SELECT against multiple tables, with joins – repeatedly. 3 Aggregation: again, it can be easier to SELECT already-aggregated data than to write the query – repeatedly.
For More Information Please Refer:

You May Also Like to Read: