Browse by Tags

Best and Worst of having indexed views in SQL 2005
Published 30 July 7 10:15 AM | SSQA.net
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...