Information générale
Catégorie:
West Wind Web Connection
>>In the case of the returning a large number of index keys, I agree. This is exactly why the last two conditions were slower because they returned nearly the entire table.
>
>I just wanted to make sure to clarify a possible confusion: you have to distinguish between returning a large number of INDEX KEYS and a large number of RECORDS. If you combine two or more conditions, one or more parts of the condition may return a large number of INDEX KEYS, although the final result may return only a few RECORDS. It is here that Full Rushmore Optimization is not always desirable. I will provide further examples if requested.
>
>Hilmar.
I'm interested. Please show me some examples.
Dan
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