Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement