Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index size
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01111388
Message ID:
01111487
Vues:
22
>>>Thread on the topic: Reindex making DBC grow... Thread #886832 Message #886832
>>>
>>>Re: REINDEX - Without EXCLUSIVE. Thread #841224 Message #841605
>>
>>I think your original answer to recreate is probably the best way
>>
>>I have just done a disp status to a text file - I can now cut and paste that into a program and be 100% sure of creating the correct indices
>>
>>Thanks for all your help
>
>See Question about the REINDEX command Thread #1003134 Message #1003134 that confirms Sergey's comment.

Interesting though

My database has 293,000 records with 54 indexes - original size of cdx file 176,084 kb following a pack and reindex

I ran a disp status to a text ile - imported the text file into a dbf - wrote a program to delete the index file and rebuild based on my database

Resultant size of cdx file exactly the same - but I ha to prove it to mysel!!

Is Sergey ever wrong?????
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform