Home Forums SQL Server 2005 SQL Server 2005 General Discussion View index not being used RE: View index not being used
happycat59
One Orange Chip
Points: 29387
More actions
August 1, 2013 at 10:30 pm
#1638043
What edition of SQL 2005 are you using ? From memory, Standard Edition will not use an index on a view unless you specify the NOEXPAND hint