{"id":22,"date":"2011-06-28T13:34:10","date_gmt":"2011-06-28T13:34:10","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/28\/advantages-and-disadvantages-of-indexed-views\/"},"modified":"2011-06-28T13:34:10","modified_gmt":"2011-06-28T13:34:10","slug":"advantages-and-disadvantages-of-indexed-views","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/28\/advantages-and-disadvantages-of-indexed-views\/","title":{"rendered":"Advantages And Disadvantages Of Indexed Views"},"content":{"rendered":"<p><strong>PROS and CONS Of Indexed Views:<\/strong><\/p>\n<p><strong>Advantages Of Indexed Views:<\/strong><\/p>\n<ul>\n<li>To Improve the performance of select queries<\/li>\n<li>Avoid Complex joins at run time and make the joined data readyly available<\/li>\n<li>Index data on columns on multiple tables<\/li>\n<li>The data from multiple tables is denormalized and helps in fastening the queries that fetch data<\/li>\n<li>Joins that are frequently used can be converted into indexed views and thus reducing the query resopnse time of multiple queries<\/li>\n<li>Advantage of having Higher Disk Space can be converted into having high query performance using Indexed views<\/li>\n<\/ul>\n<p><strong>Disadvantages Of Indexed Views:<\/strong><\/p>\n<ul>\n<li>Slows down the performance of the insert,update,delete statements on the tables used in indexed views<\/li>\n<li>Increases the disc space used by the database as the views are created with physical data<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>PROS and CONS Of Indexed Views: Advantages Of Indexed Views: To Improve the performance of select queries Avoid Complex joins at run time and make the joined data readyly available Index data on columns on multiple tables The data from multiple tables is denormalized and helps in fastening the queries that fetch data Joins that&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86,3],"tags":[],"class_list":["post-22","post","type-post","status-publish","format-standard","hentry","category-indexed-views","category-sqlserverpedia-syndication"],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/22","targetHints":{"allow":["GET"]}}],"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=22"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/22\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}