-----Original Message----- Has anybody ever created their Oracle Text index as transactional? Such as: create index myidx on mytable(mycolumn) indextype is ctxsys.context parameters ('transactional'); _________________________________________________________________ -- (Untested but) I would not be surprised if you get the same kind of index degradation that used to be the result of running ctxsrv... Cheers Connor -- //www.freelists.org/webpage/oracle-l