Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DELETED() and Rushmore
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00262005
Message ID:
00262101
Vues:
18
>Hi Colin,
>
>>I've inherited an app that for most of its tables has index tags with a FOR !DELETED() filter expression. Is this beneficial or no?
>
>
>Depends on how you use them. For Rushmore these indexes are non-existant. IOW, only SEEK is able to make use of this index, and of course SKIP or SCAN WHILE constructs.
>
>Christof

Do you mean that Rushmore doesn't use the index at all or that it just ignores the filter expression?
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada

cmagee@metroland.com

Never mistake having a career with having a life.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform