Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> create text index as transactional

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US