Friday, April 27, 2012

advantages and disadvantages of Indexed views

Advantages of indexed views
  • To Improve the performance of select queries
  • Index data on columns on multiple tables
  • The data from multiple tables is denormalized and helps in fastening the queries that fetch data
  • Avoid Complex joins at run time and make the joined data readyly available
  • 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
  • Increases the disc space used by the database as the views are created with physical data
  • Slows down the performance of the insert,update,delete statements on the tables used in indexed views.

No comments:

Post a Comment