Home Forums SQL Server 2008 SQL Server 2008 - General query tuning (PFA, execution plan and indexed view)- need help to enhance performance RE: query tuning (PFA, execution plan and indexed view)- need help to enhance performance
Lynn Pettis
SSC Guru
Points: 442467
More actions
February 5, 2013 at 8:55 pm
#1584710
One thing that your plan indicates is that there are no statistics on the the columns _col_1 or _col_2 on your indexed view. You might start there.