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 are frequently used can be converted into indexed views and thus reducing the query resopnse time of multiple queries
- Advantage of having Higher Disk Space can be converted into having high query performance using Indexed views
Disadvantages Of Indexed Views:
- Slows down the performance of the insert,update,delete statements on the tables used in indexed views
- Increases the disc space used by the database as the views are created with physical data