I have thought trigger that cause the problem. However, the trigger
is nothing to do with this field. Moreover, the update performance
does not improve although I remove the trigger.

rgds, chooi-ting

--- In ib-support@yahoogroups.com, Lucas Franzen <luc@r...> wrote:
>
>
> 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.