>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.
>
Views don't have indexes of their own as a part of the DBC; in order to maintain an index on a view, you have to build it each time, and you must chagne to row-level buffering for the duration of the indexing operation. I believe there's a FAQ entry on creating indexes for views.