Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fragmentation and index maintainence
In article <40aa63a9$0$8987$afc38c87_at_news.optusnet.com.au>, Howard J.
Rogers says...
> Jeremy wrote:
>
> >
> > Intermedia Text indexes need regular rebuilds otherwise the query
> > performance can be severely degraded.
> >
>
> In the first place, I can't see any reference to intermedia in the OP's
> question.
I threw it in because the OP was referring to fragmentation of indexes and the 'rules of thumb' that people may use to mange their rebuild. As intermedia text indexes are 'indexes' I thought I'd contribute my experience.
> And secondly, where's the statistics/test case to back that
> statement up?
>
Practical experience with 8.1.7.4
We run ctxsrv in the background to automatically update the indexes as documents are added/updated/removed.
Rebuilding the text index (by dropping and recreating the index) yields a massive performance gain. Whether this is attributable to poor design/implementation of the application I couldn't say, but the scenario holds true.
cheers
-- jeremyReceived on Wed May 19 2004 - 02:04:51 CDT