Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting indexes
Message
De
07/07/2000 16:15:21
Jonathan Cochran
Alion Science and Technology
Maryland, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00389651
Message ID:
00389662
Vues:
16
There is an ALTER TABLE command that will let you create a primary key.

>I have a form that inserts a couple of million records into a table from a text file. This process seems to get slower and slower the longer it runs.
>
>I would like to delete the indexes on this table before reading in the data. Hopefully this will speed thinks up.
>
>I found the delete tag command that actually deletes the cdx file. Is there a way to recreate these indexes programmatically when everything is done. I looked at the index command, but I don't think this will work because I need on of the indexes to be primary.
>
>Is there another way to do this?
>
>Thanks
>
>Pat Murphy
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform