Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
REINDEX verses INDEX ON
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00158654
Message ID:
00159093
Vues:
18
>Hi,
>
>I have a technical query:
>
>I have a database of 200,000 records that I have imported into a new (identical) structure with 36 indexes in the CDX.
>
>I would like to know if Foxpro will have problem with index tree balancing.
>
>If so will recreating the index correct this.
>
>The main question is should we re-create the indexes using INDEX ON from scratch OR REINDEX. The more detailed the better.
>
>Any ideas,

Actually, it would be faster to not have any indexes. You should then import the data, then INDEX ON.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform