VALIDATE INDEX

Under Oracle V6 you could do a VALIDATE INDEX and one of the pieces of information returned was the amount of ALLOCATED space that the index was ACTUALLY using.

We used this facility to monitor index growth and schedule resizing work etc etc.

Under Oracle7, the VALIDATE INDEX command is being phased out.

I have modified our procedures to use ANALYZE INDEX but the one important thing missing is the ACTUAL space used for the index.

I can find this out for TABLEs by checking ROWIDs and counting blocks etc but I can't work out a way to do this for INDEXes.

Q. Does anyone know of a way to determine what blocks are actually being used

   within the set of allocated blocks for an INDEX?                           

Reply directly and I will summarise for the net.                           

Any help greatly appreciated.                           

-- 

Bruce...        pihlab_at_cbr.hhcs.gov.au

*******************************************************************


* Bruce Pihlamae  --  Database Administration                     *


* Commonwealth Department of Human Services and Health            *

* Canberra, ACT, Australia                        (W) 06-289-7056 *

*=================================================================*


* These are my own thoughts and opinions, few that I have.        *


*******************************************************************

"The more complex the argument gets, the easier it is to refute."
"Killing is wrong!"  -- Trent 'The Uncatchable' Castanaveras