And what about sweep interval?
--

*__________________________________________________________________*
*Marcos Vinicius Dufloth*
*Diretor de Tecnologia*

*Cyber Informática Empresarial*

*marvin@...* <mailto:marvin@...>

*http://www.tecnocyber.com.br* <http://www.tecnocyber.com.br/>

*__________________________________________________________________*


Martijn Tonies wrote:

>>>> 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
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
>

[Non-text portions of this message have been removed]