Information générale
Catégorie:
Codage, syntaxe et commandes
There must be a matching index for Rushmore to kick in. Let say you have SET FILTER TO VAL(cField), then you must have an index on VAL(cField).
What do you have against views?
>I have a single character indexed field that is used to split a 2 million record table into 4 categories. I have check boxes to turn on what segments of the list are visible. The filter does not appear to be utilizing Rushmore. It is very, very slow. Setting the filter in the index would expand my required index from 8 to 120!! (every combination)
>
>I've tried the filter with INLIST and with a simple "or" statement.
>
>Any Suggestions how to filter to data without restructuring the database or using Views?
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