Re: Treedump output

Try deleting a few rows from the table
and see what happens to the treedump.

I believe that nrows is the number of currently row index slots including deleted rows,
rrows is the number of row index slots
which would be in use if the deleted rows were cleaned out.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

rbbdsb wrote in message ...


>Hi,

>  I've read recommendations about analyzing indices via the output from a

>treedump.  I suspect nrow is the number of rows, as in there are 42 branch

>blocks and the first branch block has 205 leaf blocks.  Does anyone know if

>this is correct and what rrow signifies?  Any other thoughts would be

>appreciated.

>

>----- begin tree dump

>branch: 0x4809a61 75536993 (0: nrow: 42, level: 2)

>   branch: 0x4809ba6 75537318 (-1: nrow: 205, level: 1)

>      leaf: 0x4809a62 75536994 (-1: nrow: 294 rrow: 294)

>      leaf: 0x4809a63 75536995 (0: nrow: 305 rrow: 305)

>      leaf: 0x4809a64 75536996 (1: nrow: 275 rrow: 275)

>      leaf: 0x480b483 75543683 (2: nrow: 247 rrow: 247)

>      leaf: 0x4809a65 75536997 (3: nrow: 282 rrow: 282)

>      leaf: 0x480b208 75543048 (4: nrow: 181 rrow: 180)

>      leaf: 0x4809a66 75536998 (5: nrow: 260 rrow: 259)

>

>Regards,

>Russ Brooks

>

>