{"id":21,"date":"2011-06-28T12:49:35","date_gmt":"2011-06-28T12:49:35","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/28\/creating-indexed-views-for-improving-performance\/"},"modified":"2011-06-28T12:49:35","modified_gmt":"2011-06-28T12:49:35","slug":"creating-indexed-views-for-improving-performance","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/28\/creating-indexed-views-for-improving-performance\/","title":{"rendered":"Creating Indexed Views for Improving performance"},"content":{"rendered":"
Creating Indexed Views for Improving performance.<\/strong><\/p>\n Indexed views are created in two steps<\/p>\n The syntax for creating the indexed view is different from that for creating a normal view.<\/p>\n Advantages Of Indexed Views:<\/strong><\/p>\n Disadvantages Of Indexed Views:<\/strong><\/p>\n Refer to the following link for complete list of Pros and Cons of Indexed Views:advantages and disadvantages of indexed views<\/a><\/p>\n Hence the decision of creating indexed views can be taken based on the following<\/strong><\/p>\n\n
\n
\n
\n