Re: Index on status field?
- From: Christo Kutrovsky <kutrovsky.oracle@xxxxxxxxx>
- To: zoran_martic@xxxxxxxxx
- Date: Fri, 8 Apr 2005 16:20:51 -0400
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@xxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
--
Christo Kutrovsky
Database/System Administrator
The Pythian Group
--
//www.freelists.org/webpage/oracle-l
Other related posts:
