What is a Materialized View in SQL ?

Creating Index on a view is called as Materialized view. We can create clustered and Non-Clustered index on the view. The data fetching will be much faster if we use this view.



create view VIEWNAME

with schemabinding


select * from tbl


After creating go to design view and create clustered and non clustered indexes appropriately.


— Author

What is a Materialized View in SQL ? was last modified: October 1st, 2017 by Justin Antony

About Justin Antony


Leave a Reply