Subject RE: [firebird-support] How to know when an index has become unbalanced?
Author Mercea Paul
Hi

However, random deletions and modification can lead to
partly filled indexes. The tool for identifying such
problems is gstat. It reports the fill level in index
pages - if it is below 70%, you should probably rebuild
the index unless the keys are very large - large keys
don't pack well into pages.

According for that it could be very usefull to have in RBS$INDICES new
column like RDB$STATISTICS for index fill level.
We could run procedure to rebuild index without using gstat .

I'm wrong?

Regards,
Paul



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