Home Forums SQL Server 2008 SQL Server 2008 - General facing a diffrent problem alltogether - working on indexed views and facing a tough time getting the query optimizer to pick the resultset from Indexed view... :) RE: facing a diffrent problem alltogether - working on indexed views and facing a tough time getting the query optimizer to pick the resultset from Indexed view... :)
Lynn Pettis
SSC Guru
Points: 442467
More actions
February 3, 2013 at 4:24 pm
#1583759
Also, have you tried using the NOEXPAND query hint when querying your indexed view?