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

Answers

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