Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it reasonable to have index on DELETED()?
Message
 
 
To
23/03/1999 22:23:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00196021
Message ID:
00201302
Views:
22
John,

I'm not sure if PACK causes a CDX rebuild. Up until the DBC got involved the common practice was DELETE TAG ALL and then issue each INDEX command to reconstruct the CDX file. REINDEX was generally avoided because it can not recover in all cases of CDX corruption.

>Maybe I'm getting senile, but wasn't it a problem several versions ago that only PACK recovered space in the CDX?
>
>>
>>>Is reindex command enough or should tags be removed?
>>
>>I did some testing and REINDEX does recover wasted space in the CDX.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform