Index health ?

 Hi ,

 How check health of an index ?

 SQL> analyze index IDX_PRODUCTS validate structure ;

 Index analyzed

 SQL> SELECT height, blocks, lf_rows, lf_blks, br_rows, br_blks, btree_space, used_space

 FROM index_stats WHERE name = 'IDX_PRODUCTS';

 HEIGHT     BLOCKS    LF_ROWS    LF_BLKS    BR_ROWS    BR_BLKS BTREE_SPACE USED_SPACE

---------- ---------- ---------- ---------- ---------- ---------- ----------- ----------

         3          7          0          1          0          0        8952

 if height <= 2 then index OK

 else KO (index rebuid is necessary ?).

 Thanks.

GD.