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: Tue, 18 May 2004 16:19:17 +0100
Message-ID: <MPG.1b1439c81cf83992989bf5@news.individual.net>


In article <c86ce4f.0405180705.6bc45f56_at_posting.google.com>, DiggidyMack69 says...
> "Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<4092660b$0$4543$afc38c87_at_news.optusnet.com.au>...
> > DiggidyMack69 wrote:
> >

<snip>

> > >
> > > What are good rules of thumb to look at in regards to when looking for
> > > signs of fragmentation and other problems of the like?
> >
> > A good rule of thumb?
> >
> > Don't bother.
> >

<snip howard's suggestions>

>
> Thanks for the info. For the record I was talking about index
> fragmentation. It has been told to me that some of my indexes are
> 'fragmented' by an 'authority'. That is all. I didn't have any stats
> or anything to back-up or disregard that claim. Thanks to folks here
> I have alot more useful information. I assume that some automated
> tool has been run to generate a report of 'fragmented' indexes.
>
> DM
>

Intermedia Text indexes need regular rebuilds otherwise the query performance can be severely degraded.

-- 

jeremy
Received on Tue May 18 2004 - 10:19:17 CDT

Original text of this message

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