Index on materialized view
Under these circumstances, creating indexes on the view can help you to improve the performance. A view created with a unique clustered index is known as an “Indexed View” or “Materialized View”. Unlike views, an Indexed View exists on the disk like a table in which the clustered index is created. Materialized views can deliver significant performance improvements for queries, but that does not mean that a materialized view can not be sped up further with the addition of one or more indexes. Indexed View or Materialized View Indexed View also known as Materialized view because they have a virtual table to store data whereas the regular view is the metadata of a query. Even though Indexed view on SQL Server has tons of limitation, you can create view to store result of a query that involves calculation or need to aggregate data.