Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexing on multiple fields....
Message
De
11/11/2000 08:38:55
 
 
À
11/11/2000 07:04:14
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00440691
Message ID:
00440694
Vues:
15
>Have someone experienced problemns with multiple field indexes, like: field1 + dtos(field2) + str(field3)... Problemns like: slow indexes, corrupted indexes, etc...
>
>I need that for primary key.
>
>Cause I have developed a database that have until 6 fields concatenated on one single tag, and the tables will have a lot of records (1 million+).
>
>Any experience will be apreciated.
>Thanks.

This isn't a good idea for a primary key. You should look at a surrogate key for a PK. There is an article on my web site that explains how to do this.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform