REINDEX

[Ruslan Zasukhin]

On 8/29/05 5:33 PM, "Andrew Sinning" <andrew at learningware.com> wrote:

Hi Andrew,

> How often should I be calling REINDEX DATABASE or REINDEX TABLE?  What
> exactly does this do?

It just trash existing index and build new one.

In ideal you should never do this.
You need od this if e.g. You see wrong results of search,
Or e.g diagnose in Valentina 2 with VeryHigh option, show problems.
 
> I've been having some db corruption problems, which I have finally
> traced to a "DELETE" query.  There's no precise pattern to this
> corruption, but once I can identify a set of steps that result in the
> corruption, I can reproduce the corruption every time.
> 
> Anyway, I have added a "REINDEX TABLE tblName" statement after the
> ofending DELETE query, and this has solved the problem.  This makes me
> think that I should be calling REINDEX after all of my DELETE queries,
> and probably after any UPDATE queries, too.  What do you recommend?

You use v1 or v2 ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]