Re: Index on status field?

I havent confirmed this with a test case, but here it is:

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
>

-- 
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l