Index on Tables used in Partiioned Viewgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I have a partitioned view, I can't create Index on that because I use computaion (non deterministic) column. My doubt is whether the view will use the index that I have created on the tables involved in the partitioned view.
-- Anonymous, December 14, 2001
With the noexpand,expand option specified the view uses the specified index.
I have implemented the same. (Had to reply for my own question)
-- Anonymous, December 17, 2001