>I developed my application by using views and parameterzied views. I am confused about my indexes I have built my indexes on my tables do I have to build indexes for my views If so where should I do this and with a large database will this not take along time. I have a grid using a view and under the header I would like to change the order and to do this I am building a index. Once I have build a index can I check to see if the index exist so I want rebuild it.
>
>Thanks Randy
The view does not really exist as a file. You will need to recreate the index each time you requery the data. Is there a reason you can't use the ORDER BY clause when you create the view?
Rushmore gets applied to the tables when the views are pulled.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer