>I am using view for Updation of table for a particular key, for that I am passing parameter in view, (And view also contains some filter conditions in where clauses) So it becomes very slow. Is there any way we can make it fast.
If the view is parameterized on the primary key, there is no need for further filters, since there will be only one record for a specific primary key value.
Also, make sure you do not have an index on DELETED().
Perhaps you can get some additional ideas for optimization, reading FAQ #8109.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
