Home Forums Article Discussions Article Discussions by Author Discuss content posted by sknox Indexed Views RE: Indexed Views
Carlo Romagnano
SSC-Insane
Points: 22590
More actions
February 10, 2012 at 1:25 am
#1445387
I know that query optimizer use index on view only for some edition, but with noexpand you can force the use of index. I still working with sql2000. In sql2008 r2, I think it would be better to use filtered index.