Subject RE: [firebird-support] How to know when an index has become unbalanced?
Author Alan McDonald
> The subject pretty much sums up the question, "How to know when an
> index has become unbalanced?"
> I know how to rebuild an index and update the statistics, but how can
> I know the state of the index itself and whether it needs rebuilding?
> Example: I have a primary key on an autoincrement column. I'd assume
> the index tree would get unbalanced rather quickly - - right?
> Thanks
> Atli

if you've done a lot of mass inserts and/or deletes, I would set stats.
Otherwise I would leave my indexes alone until normal backup/restore type
maintenance operations.
PK fields don't go out of balance quickly - quite the reverse.