Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: fragmentation and index maintainence

Re: fragmentation and index maintainence

From: Jeremy <newspostings_at_hazelweb.co.uk>
Date: Wed, 19 May 2004 08:04:51 +0100
Message-ID: <MPG.1b151762687a0c11989bf6@news.individual.net>


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

-- 

jeremy
Received on Wed May 19 2004 - 02:04:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US