RE: Index on status field?
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <zoran_martic@xxxxxxxxx>, <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 22:22:52 +0200
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.
---------------------------------------------
Visit my website at http://www.naturaljoin.nl
---------------------------------------------
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Martic Zoran
Sent: Friday, April 08, 2005 22:05
To: Oracle-L@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
