RE: Index on status field?

From: Martic Zoran <zoran_martic_at_yahoo.com>
Date: Fri, 8 Apr 2005 14:50:08 -0700 (PDT)
Message-ID: <20050408215009.15477.qmail@web52601.mail.yahoo.com>

Riyaj,

Thanks a lot.

Lex, thanks to you too.

This finally explains everything.

Of course that there is nothing else Oracle can use that is smart enough to populate the missing index slots.

It looks very consistent that whetever is deleted in the table should soon be populated and so the index entry will be reused.

Smart at the end. Maybe the easiest method anyway, because rowid needs to be there.

I believe I am not the only one not knowing this ;) I basically never needed to think about this till now. But again this is not excuse for not knowing it :)

Regards,
Zoran

• Riyaj Shamsudeen <rshamsud_at_jcpenney.com> wrote:

> Zoran


> 	AFAIK, even non-unique btree indices are unique ;-)

> 	By combining non-unique columns and rowid



		
__________________________________ 

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 - 20:16:48 CDT