Re: Index on status field?

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 8 Apr 2005 13:05:16 -0700 (PDT)
Message-ID: <20050408200516.77774.qmail@web52601.mail.yahoo.com>

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

Received on Fri Apr 08 2005 - 16:09:09 CDT