Re: fragmentation and index maintainence

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 18 May 2004 22:21:05 -0700
Message-ID: <1084944068.838328@yasure>

Paul Drake wrote:

> Jeremy <newspostings_at_hazelweb.co.uk> wrote in message news:<MPG.1b1439c81cf83992989bf5_at_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,
>
> that's not a rebuild in terms of index fragmentation, the fact that
> explicit maintenance is required is due to the fact that intermedia
> context indexes are not maintained synchronously, so the become
> "STALE", not fragmented.
>
> Oracle maintains b*tree and bitmap indexes synchronously, and
> recursively.
>
> There are 2 methods possible for synching the context indexes,
> internally via a dbms_job calling a procedure, or externally via the
> ctxsvr executable.
>
> IIRC, Daniel Morgan has posted in the past that he prefers the
> internal method due to some conditions that can cause the indexes to
> become larger via the external routine. Maybe he'll refresh us as to
> what he specifically mentioned.
>
> Pd

I have no recollection of having ever posted anything related to Context | InterMedia | OracleText.

Either my memory is failing or you'll have to cast a wider net to find the person that wrote on the subject.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Wed May 19 2004 - 00:21:05 CDT