Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: fragmentation and index maintainence
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.
-- jeremyReceived on Tue May 18 2004 - 10:19:17 CDT