• From MSDN,

    http://msdn.microsoft.com/en-us/library/ms187864%28v=sql.105%29.aspx

    Indexed views work best when the underlying data is infrequently updated. The maintenance of an indexed view can be greater than the cost of maintaining a table index.

    Plus also keep in mind

    an indexed view cannot reference tables from more than one database.

    ----------------------------------------------------