This is the fourth article in a series of learning the CREATE VIEW SQL statement. So far, we have done a great deal of creating and altering views using T-SQL. In this last part, I want to take a big look at how to work with indexed views.
Read more »![Bojan Petrovic](https://s33046.pcdn.co/wp-content/uploads/2021/01/boksi-1.jpg)
![Execution plan of a SELECT statement without an index on a view showing multiple tables scans in the execution plan](https://s33046.pcdn.co/wp-content/uploads/2020/03/execution-plan-of-a-select-statement-without-an-in-624x374.png)