Alexander,
Although I index this column, the performance is still the same. or
even slower.

So, I execute "gbak -b -g" to clear the garbage. I don't see any
improvement too.

regards, Chooi-Ting


--- In ib-support@yahoogroups.com, "Alexander V.Nevsky" <ded@h...>
wrote:

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