treedump versus validate structure

From: Russ Brooks <russ.brooks_at_dayzim.com>
Date: 11 Jun 2002 07:32:40 -0700
Message-ID: <a7f817f2.0206110632.92a07da@posting.google.com>

Hi,
I'm looking into rebuilding some indices and have seen recommendations to use treedumps instead of doing a validate structure on the index. I have a couple of questions. 1. To obtain the percentage of deleted rows, would something like 1-(rrow/(nrow - rrow))*100 for the leaf blocks work? Is there a better way?
2. To obtain the height of the index, do you count the number of branches?
3. Is there any table locking or known performance impacts that would argue against doing a treedump?

If anyone has compared the performance between the two methods, I'd be very interested in hearing from you.

Thanks,
Russ Brooks Received on Tue Jun 11 2002 - 09:32:40 CDT