Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL, Indexes 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:
00202421
Message ID:
00202562
Vues:
12
I don't think this is true. For Rushmore to take effect, you need to match the index expression EXACTLY. In this case, if an index expression is based on the concatenation of two fields, the where or for clause also needs to concatenate the expression. Otherwise, VFP will not be able to find the correct index expression to use.

In terms of creating one bitmap versus two, I think this issues is all that relevant. Matching the index expressions and having a deleted tag on the other hand, is....

>>You might see a bit better performance from the compound index because VFP creates a bitmap with a bit for each record in the file and a 1 for each record that matches the index and a 0 for each one that doesn't. For two indexes it has to create two bitmaps and then AND them together to figure out which records match.
<<
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform