Re: Index on status field?

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 8 Apr 2005 08:55:55 -0700 (PDT)
Message-ID: <20050408155555.79577.qmail@web52605.mail.yahoo.com>

Christo,

Thanks a lot.

> A block can be reused only if all entries from it
are removed, or a new entry's place is arround entries
> in that block (based on your key and rowid)
This is what I want to know more.

My entry will be 0, the same so when it is going into the block that is not fully emptied (put back to the free list).

If it is not by the free list then how?

Regards,
Zoran

• Christo Kutrovsky <kutrovsky.oracle_at_gmail.com> wrote:

> Imagine an ordered list, ordered by YOUR_INDEX_KEY,
> rowid.
>
> Your index will have:
>
> -- Block 1 --
> 0, AAAb... 1
> 0, AAAb... 2
> 0, AAAb... 3
> 0, AAAb... 101
> 0, AAAb... 350
> ...
> -- Block 2 --
> 0, AAAb... 551
> 0, AAAb... 800
> 0, AAAb... 950
> 0, AAAb... 1001
> 0, AAAb... 1002
> ...
>
> As long as you dont leave unprocessed behind, as the
> entries are
> removed, blocks in the begining of the list will be
> emptied, and thus
> reused later on. A block can be reused only if all
> entries from it are
> removed, or a new entry's place is arround entries
> in that block
> (based on your key and rowid)
>
> The approach you have chosen is pretty much optimal.
> The one thing i
> would add is to maybe compress the index, but i am
> not sure wehter you
> will save much at all, given that you field is
> already number(1).
>
> Does that answer your question ?
>
                

---

Yahoo! Messenger
Show us what our next emoticon should look like. Join the fun. http://www.advision.webevents.yahoo.com/emoticontest

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

Received on Fri Apr 08 2005 - 12:01:26 CDT