Subject Re: [firebird-support] Performance Degrade - HELP
Author Martijn Tonies
> > > Oldest transaction 4725
> > > Oldest active 4726
> > > Oldest snapshot 4726
> > > Next transaction 4882
> > > Bumped transaction 1
> >
> >Those are the transaction numbers (above).
> >
> >Is this from a slow moment?
>
> Hmmm, Martijn, scroll down and look at the index statistics!!!

Ehm... I'm not very good at reading those -

But, eh - I would say there are some indices with a lots of
duplicates (low selectivity = bad).

Would that be alright?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com