Viewing 2 posts - 1 through 3 (of 3 total)
It looks like indexed views do use their index without NOEXPAND option on Developer edition too.. Please try below test script.
The execution plans for last two statements shows the usage...
July 26, 2009 at 5:46 pm
#1030336
I am using SQL Server 2005 Dev edition(SP3) and situation is same on SQL server 2008 dev edition too
July 23, 2009 at 3:28 pm
#1029317