Stephen A. Fuqua (saf)

a Bahá'í, software engineer, and nature lover in Austin, Texas, USA

MSSQL 2005: Indexed Views

Good article on using indexed views: Indexed Views Basics in SQL Server. Similar good coverage in Ben-Gan’s Inside Microsoft SQL Server 2005: T-SQL Programming. Problem: both specify that the hint WITH(NOEXPAND) needs to be used when executing a query against the index on anything other than Enterprise and Developer. However, I’ve found that it is also required for Enterprise.

Posted with : Tech, SQL Server