Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Corrupt index how to rebuild safely on large table
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Corrupt index how to rebuild safely on large table
Miscellaneous
Thread ID:
00157066
Message ID:
00157066
Views:
74
I have a foxpro 2.6 table with over 800,000 records in it. When I do a reindex or pack on it, what appears to be an infinite loop of indexing happens. I have let the table reindex for over an hour and it just keeps on reindexing (more than the number of individual indexes on the cdx file). Has anyone seen this behaviour?

What is a safe way to rebuild the CDX? Should I delete all of the indexs (using the table properties screen) then delete the CDX file, then create a new one? Or can I simply delete the CDX? I don't want to corrupt this table.
Next
Reply
Map
View

Click here to load this message in the networking platform