RE: Index on status field?

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 8 Apr 2005 13:56:19 -0700 (PDT)
Message-ID: <20050408205619.74162.qmail@web52609.mail.yahoo.com>

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_at_naturaljoin.nl> 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

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 08 2005 - 17:00:13 CDT