Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Understanding Rushmore optimization
Message
De
12/07/2016 09:42:55
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01638260
Message ID:
01638269
Vues:
83
Press F1, and look up "INDEX Command"

>I will have to learn where and how to add the Binary keyword to the logical index. Thank you.
>
>>If you need an index on a logical field or on deleted(), make sure to add the Binary keyword when you create it. That will make the index much smaller, meaning much faster.
>>
>>>The more it makes sense for me to get rid of it. Thank you.
>>>
>>>>Any index on a binary value will generally not be very effective. I've heard some people say that an index on DELETED() is effective if you have a high number of deleted records, but never tested this myself.
>>>>
>>>>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform