analyze index

From: <daud11_at_hotmail.com>
Date: Wed, 04 Nov 1998 11:24:43 GMT
Message-ID: <71pdhp$ate$1@nnrp1.dejanews.com>

I found out that after doing 'analyze index <index-name> validate structure' I can get some statistics on the index from index_stats. However, I do not know much to interpret what the numbers mean. In particular, I would like to know when is it necessary to rebuild an index.

Many thanks
Daud

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 04 1998 - 05:24:43 CST