Re: Index rebuilds

Where did you get the line about the last block never being filled more than 100-PCTFREE ? I've not seen it before. It's fairly easy to prove that it's not (always) true - but I'd be interested to see a test case that demonstrates it.

It is true that Oracle reports a statistics called something like:

    index leaf splits 90/10

But to date, I've never seen a 90/10 split, only things that are roughly 50/50 splits, and things that could be called 100/0 splits - the latter being things that then record under the 90/10 statistic.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Iceland__November (tbc)
____Belgium__November (EOUG event)
____UK_______December (UKOUG conference)


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____USA__October
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Luc Gyselinck" <Luc.Gyselinck_at_nospampandora.be> wrote in message
news:C01hb.66925$lm5.3419194_at_phobos.telenet-ops.be...


>

>                                    , with one exception: the 'last'

block in the index is


> never filled for more than 100-PCTFREE percent; a new block is

allocated if


> the last block goes beyond 100-PCTFREE percent used.

>