Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Primary Index
Message
De
06/04/2001 08:30:28
 
 
À
05/04/2001 19:58:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00492553
Message ID:
00492741
Vues:
30
>>
>>The other camp says that the PK should only be applied to non-deleted records. You can build a filtered index on the PK that ignores deleted records. Keep in mind that a filtered index will not be used by Rushmore.
>
>. . .but of course a second index on the same field but without the filter puts Rushmore into action again.

Yup. Just keep remember there is additional overhead to update a second, and IMO, unneeded index. Don't reuse keys and the problem won't exist.
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