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?

Thanks for any suggestions.