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

Leave a Reply

Your email address will not be published. Required fields are marked *