{"id":237,"date":"2012-06-04T08:10:08","date_gmt":"2012-06-04T08:10:08","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/06\/04\/materialized-views-in-sql-server-with-example\/"},"modified":"2012-06-04T08:10:08","modified_gmt":"2012-06-04T08:10:08","slug":"materialized-views-in-sql-server-with-example","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/06\/04\/materialized-views-in-sql-server-with-example\/","title":{"rendered":"Materialized views in sql server with example"},"content":{"rendered":"<p>Materialized views in SQL Server are equivalant to Indexed views.<\/p>\n<p>Below links have More details:<br \/>\n<a href=\"http:\/\/sqlserverlearner.com\/2011\/creating-indexed-views-for-improving-performance\" target=\"_blank\" rel=\"noopener noreferrer\">Creating indexed views in SQL Server<\/a><br \/>\n<a href=\"http:\/\/sqlserverlearner.com\/2011\/advantages-and-disadvantages-of-indexed-views\" target=\"_blank\" rel=\"noopener noreferrer\">Advantages and disadvantages of indexed views<\/a><\/p>\n<p>How to create materialized view in sql server?<br \/>\nExample:<br \/>\n[sql]<br \/>\nCREATE VIEW vwTest<br \/>\nWITH SCHEMABINDING<br \/>\nAS<br \/>\n    SELECT id, name FROM Products where id &gt; 1000<\/p>\n<p>GO<\/p>\n<p>&#8211;Create an index on the view.<br \/>\nCREATE UNIQUE CLUSTERED INDEX ix_vwTest<br \/>\n    ON vwTest (id)<br \/>\nGO<br \/>\n[\/sql]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Materialized views in SQL Server are equivalant to Indexed views. Below links have More details: Creating indexed views in SQL Server Advantages and disadvantages of indexed views How to create materialized view in sql server? Example: [sql] CREATE VIEW vwTest WITH SCHEMABINDING AS SELECT id, name FROM Products where id &gt; 1000 GO &#8211;Create an&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/237"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/237\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}