i execute the update query at isql prompt. i play around with the
indiinitialized value by switching from 0 to 1 and vise versa.

I just tried it...issue a commit immediately after the update will
make the update process faster, within 5 sec.

thanks for your help.
rgds, chooi-ting

--- In ib-support@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@k...> wrote:

>
> >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.
>
> Well, then we need a lot more information to help you, because this

statement

>
> >When I issued the below sql query:
> > update HistCurr set IndiInitialized = 1
>
> by itself should execute within second(s) when the table contains

only a

> few thousand records.
>
> Though there is one thing you haven't answered yet: What is the

difference

> between next transaction and oldest active transaction (OAT)?

Another

> question is if you run this statement by itself, or as part of a

larger

> operation, e.g. following a huge delete.
>
> Set