REINDEX is OK when index definitions are still here
DELETE TAG ALL and INDEX merely rewrites index definitions in DBF header
and DBC
Thierry Nivelet
FoxInCloud
Give your VFP app a second life in the cloud
http://foxincloud.com/
Le 09/11/2016 à 18:51, [email protected] a écrit :
Thierry -- are you using REINDEX or DELETE TAG ALL and rebuilding each
manually?
On 2016-11-09 11:31, Paul Newton wrote:
I thought I read somewhere that REINDEX does not reduce bloat and that
to reduce bloat you DELETE TAG ALL and recreate the tags
-----Original Message-----
From: ProfoxTech [mailto:[email protected]] On Behalf Of
Thierry Nivelet
Sent: 09 November 2016 15:53
To: [email protected]
Subject: Re: Do you rebuild your indexes every night or do you leave
them alone.
I've seen CDX size divided by 10 after REINDEX
Thierry Nivelet
FoxInCloud
Give your VFP app a second life in the cloud http://foxincloud.com/
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.