create text index as transactional

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 01 May 2007 14:11:51 -0500
Message-ID: <BAY133-F457E7D59043849B58A09397430@phx.gbl>

Has anybody ever created their Oracle Text index as transactional?

Such as:

create index myidx on mytable(mycolumn)
indextype is ctxsys.context
parameters ('transactional');

I have been reading oracle's docs with statements like:

"cost for evaluating a single unindexed rowid can be fairly high.. "

Does anybody have expierence with this?

thanks.

---

Download Messenger. Join the i’m Initiative. Help make a difference today. http://im.live.com/messenger/im/home/?source=TAGHM_APR07

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

Received on Tue May 01 2007 - 14:11:51 CDT