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 23:21:27 +0200
Zoran,
like someone else suggested, Oracle B*-tree indexes are indeed *always* unique.
for indexes created non-unique (as in your case) the ROWID becomes part of the
index key;
if you create unique indexes yourself, the ROWID becomes part of the entry
header.
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:56
To: Lex de Haan; Oracle-L@xxxxxxxxxxxxx
Subject: RE: Index on status field?
Hi Lex,
Thanks for the answer.
Again did not get it.
Do you mean exact value as the separator or rowid for that value?
What I have are 1M rows with the same value 0.
When I delete some of them a few entries are left empty.
Some of these entries are reused and some of them not after inserting few 0
again.
I used analyze validate structure with
select lf_rows, del_lf_rows from index_stats;
but did not get it. It is not sequential. It can be based on the rowid though as
Christo pointed.
But how it works exactly?
Is your separator rowid from the branch block?
This will mean if the row is going to the same entry in the table the index
entry will go to the same index empty entry ...... crazy or is it?
Even Jonathan Lewis articles did not point me to the answer, the same with
asktom.
I probably missed it somewhere.
Regards,
Zoran
--- Lex de Haan <lex.de.haan@xxxxxxxxxxxxxx> wrote:
> 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.
__________________________________
Do you Yahoo!?
Yahoo! Personals - Better first dates. More second dates.
http://personals.yahoo.com
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
