Index on Tables used in Partiioned View : 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.

Please clarify

-- 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)

Regards DeepaRajesh

-- Anonymous, December 17, 2001

Moderation questions? read the FAQ