SQL Server Performance

Best and Worst of having indexed views in SQL 2005

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 30, 2007.

  1. Anonymous New Member

    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...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/07/30/1188.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1188" width="1" height="1">

Share This Page