--- In ib-support@yahoogroups.com, "goonct" <goonct@w...> wrote:

> 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 ?

Chooi-Ting, first idea - you have index on this column. Second -
sweep was not made on this database for ages and it have huge oldest
active transaction - active transaction gap and contains tons of
garbage.

Best regards, Alexander.