Imagine again a long list, ordered. It covers 10 pages. On 2 of the
pages, you have 2 empty lines (slots). You have the ability to rewrite
a single page, without touching the other pages.

You are going to basically use (or re-use) the slots when a given
entry has to go AFTER the last entry of the previous page AND BEFORE
the first entry of the next page. Anywhere within that page, Oracle
will re-arrange it and insert the "item".

I hope my example was some-what helpfull. I can try harder if needed :)

On Apr 8, 2005 4:05 PM, Martic Zoran <zoran_martic_at_yahoo.com> wrote:
> Christo,> > I understand the general mechanism about indexes and> tables.> What is left is:> > Remember i said the ordering was index key,> > rowid.> How is that working? To say that you have 10 blocks> where there are 2 slots left in each.> When and how is that going to be reused exactly?> Which algorithm is that? Some ORacle specific?> > That is what I am searching if anybody knows.> > I did not get that from your answer, but it is good> point. Where did you find out it depends on speific> rowid when the value is the same? Probably some> doc/note?> > Regards,> Zoran> > __________________________________> Do you Yahoo!?> Yahoo! Personals - Better first dates. More second dates.> http://personals.yahoo.com> > --> http://www.freelists.org/webpage/oracle-l>