| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Index on status field?
Hi Zoran,
this depends on the separator values in the branch blocks just above the leaf
blocks -- these separator values decide in which leaf block an entry goes.
kind regards,
Lex.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On
Behalf Of Martic Zoran
Sent: Friday, April 08, 2005 22:05
To: Oracle-L_at_freelists.org
Subject: Re: Index on status field?
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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 08 2005 - 16:26:49 CDT
 |
 |