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@...