gtschech (6/15/2010)
But I wonder if maybe I should switch to an indexed view for better View retrieval performance.
it depends on the main base tables transactions , if there is huge DML operation then you wont get much benefits but above of all "IT DEPENDS". So better test it.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)