>Does the table have an index on the key field(s) you're using to update it?
>
>>It takes us at around 2 minutes to just update a single record edited on a sql view. Why is it so? The table contains 1 million records
Yes, it has. Why is it still like that?