goonct schrieb:

>
> Hi,
>
> When I issued the below sql query:
> update HistCurr set IndiInitialized = 1
>
> It took 6-7 minutes to complete the update. This table only consists
> of 5000 rows.
>
> Do you know how to improve the performance ?

I'm quite sure you have some update triggers involved on that table.
Have a look what they're doing and if they really have to do anything
when you're just doing anupdate on that one field.

Luc.