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