Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ConText Index Maintenance - Optimize Blocking Sync
"at"@" <""caoimhinocrosbai(at\"@)yahoo.com"> wrote in message
news:1118329795.0a7be6b2d48bcf5e9de2fbd8fda9904a_at_teranews...
> Tim Arnold wrote:
>
> >
> > You might try ctxsrv. I know is not the 'supported' way to maintain
> > indexes, but it works
> >
> >
>
> Didn't think to try that... does it work differently to
> sync_index/optimize_index from pl/sql such that blocking will not occur?
Never had a problem w/blocking. I have eight Text Indexes on one table. The supposed problem is index fragmentation - I believe ctxsrv just keeps adding records (which would support the notion of not blocking) Received on Tue Jun 14 2005 - 07:55:31 CDT