>Just wondering if someone could perhaps answer a question I have regarding views. Currently I have a table with approximately 121,000 records. For the most part I will only be query that one table. I expect my result set may range from 100 to 1000. I have elected to use updatable views instead of setting filters. After the result set is obtain I have to replace certain field from the query (user doesn't do any direct editing). That is because this is a step by step process. My basic question then is a views faster in this instance or are filters. I much prefer to use the view but haven't done any testing on using views instead of filters.
>
>Thanks

Do you mean using parameterized views that only return a subset of the 100k+ records versus retrieving all the records and then filtering on the client side? Is this a local or remote table? I am guessing this is a local table.

My first suggestion is that you make sure you have indexes that exactly match all your filtering criteria. For example, if one of the filters is UPPER(LASTNAME), make sure you have on index on UPPER(LASTNAME).

If this is a local table, and you have all the appropriate indexes, the method of updating is not going to make much difference.

If this is a remote table, parameterized views are definitely much better. You should only retrieve the records you need to work with.