Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reindex vs Index
Message
From
04/07/2003 05:24:32
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00806873
Message ID:
00806898
Views:
15
REINDEX relies on tag information stored in the header of the CDX file. If this information should become corrupted, the new index will be invalid as well. INDEX won't have this problem because you specify the tag information.

However, using either INDEX or REINDEX could cause index bloat (see the article on my web site). For this reason, I recommend you delete the CDX and use INDEX. However, this too has its problems as it will also remove any persistant relations setup in the DBC. You'll need to recreate them also. A good tool that handles all this for you is Stonefield Data Tools.

>Dear All,
>I want to know what's the different
>using reindex and Index...
>
>
>Cause it's start to confuse me when i;m dealing with a large records
>and become corrupted because when the electricity went off the table become incosistent...
>
>I don;t how to fix it (at that time)
>Someone said i should use Indexing again...
>but i think why don't use reindex ?
>
>Could any of you tell me which the better...
>
>thx
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform