Subject Re[2]: [firebird-support] Re: High CPU consumption
Author Alexander Tabakov
Hello Ann,

Thank you for your last post regarding table and index statistics.
This was actually one of the most valuable posts I've seen on this
list :)).

So, following your directions I did a gstat and observed results. Now
I have 2 questions:

1. Most of my indexes with "max versions" > 30000 were used in foreign keys. So,
what is your recommendation in that case? Maybe I should use some kind of
trigger based referential integrity?

2. I found an index with very good selectivity (0,0000063...), but
which contains about 35K records with null value. So statistics
shows "max versions = 35K". Is this a problem?

Best regards,
Alexander mailto:saho@...