Re: B-Tree index

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Wed, 6 Nov 2002 15:43:40 GMT
Message-ID: <3DC938AC.2058C850@peasland.com>

Your B-tree index will always be balanced. That's part of its definition! What you really want to check is to see if the leaf nodes are "empty". You can do this by issuing the following command:

ANALYZE INDEX index_name VALIDATE STRUCTURE;

Then query V$INDEX_STATS comparing the deleted leaf nodes to the total number. If this percentage is too high, then rebuild the index.

HTH,
Brian

Harry Sheng wrote:
>
> How can I check if a B-Tree index (suppose it is not too big) is well
> balanced ?
Received on Wed Nov 06 2002 - 09:43:40 CST