| 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?
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.
-----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:56
To: Lex de Haan; Oracle-L_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 08 2005 - 17:25:22 CDT
 |
 |