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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
