Consider to have indexed view if the queries are accessing using a f requently occurring aggregations and joins. Irrespective of whether or not a query is asked frequently, it may be a candidate for an indexed view if it takes significant time to answer, and the value of getting the answer quickly is high. Not all queries will benefit from indexed views. Similar to ordinary indexes, if the indexed views are not used, there is no benefit. As the BOL explains: a query optimizer considers indexed views...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/perftune/archive/2007/07/30/1188.aspx