Subject | Re: [firebird-support] Performance Degrade - HELP |
---|---|
Author | Martijn Tonies |
Post date | 2003-10-10T12:16:20Z |
> > > Oldest transaction 4725Ehm... I'm not very good at reading those -
> > > 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!!!
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