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?


Download Messenger. Join the i?m Initiative. Help make a difference today.


Other related posts: