They are tantilizing are they not? The idea of having the DBMS store and maintain the materalized output of your view to disc sounds like it would be great. My experience however, has shown that they have very few real world uses. The restrictions on their creation makes them nearly usuable in most projects. You can't use Left Joins. You can't use Cross Apply. You can't use subqueries. You can't use Exists clauses and on and on and on... What is left are the most simplistic of queries in which you wouldn't consider using an indexed view in the first place!
Subscribe