REINDEX

[Andrew Sinning]

Ruslan Zasukhin wrote:

>>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.
>  
>
Okay, I will look into building this into my error checking in instances 
where a query returns 0 results.

> 
>  
>
>>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 ?
>  
>
v1.11 V4MD