--- In firebird-support@yahoogroups.com, "Vlad Khorsun" <hvlad@...> wrote:

>
> >> > how resolve this problem ?
> >>
> >> Rebuild the corresponding index
>
> > No any help : can comment me do it when some user work with this table ?
>
> ALTER INDEX ... ACTIVE; COMMIT;
>
> While index is builds users can read from table but can't modify it
>
> Regards,
> Vlad
>
> PS Do you want to say that your database works in 24x7 mode ?
>

Hi vlad


YES , Absolutely 24X7 , DB

first i can understand what table BUT i have multiple index for this
table then can not understand what index(s) of this table have problem...
then how use ALTER INDEX ... ACTIVE; COMMIT ?

one note i point to it : i have *always* problem with one table of over thousand of tables in my db only one table
also other note this table have used in one *heavy load* recursive stored procedure (get over 50 sec to finish) one other *hungry*
user work with this table ...