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