>>> Is there a way to completely regenerate all indices in a database
>>> without running through the full backup/restore cycle? It's been my
>>> experience that over months or years, the database keeps getting slower
>>> and slower, but a backup and immediate restore fix it to run at
>>> full-speed again. I would like to achieve the same result without having
>>> to stop all other work. What I tried so far:
>>>
>> Are you sure that the index stuff is your problem and not transaction
>> related? What's the output of gstat -h at the time you think the
>> database is getting slow?
>
> No, I am not sure. I will try to get gstat -h for the slow database (I
> can't do it right away as I am only getting backups from my users, not
> the production databases themselves). What should I be looking for?

Simply post the output here and someone gets a hold on that and
discusses the result.



--
With regards,

Thomas Steinmaurer
Upscene Productions
http://www.upscene.com
http://blog.upscene.com/thomas/

Download LogManager Series, FB TraceManager today!
Continuous Database Monitoring Solutions supporting
Firebird, InterBase, Advantage Database, MS SQL Server
and NexusDB!