Subject | RE: [firebird-support] How to know when an index has become unbalanced? |
---|---|
Author | Mercea Paul |
Post date | 2007-02-20T09:24:55Z |
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]
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]