create text index as transactional

  • From: "Joe Smith" <joe_dba@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 01 May 2007 14:11:51 -0500

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


Other related posts: