>>35,000 records
>>set filter to fielda = a and fieldb = b and fieldc = c
>>indexes on major fields
>>
>>for the filter I have an index like this:
>>index on fielda+fieldb+fieldc tag tag1
>>
>>Thanks for your suggestions
>>
>Jeff,
>
>Your index is wrong for Rushmore. You need three indexes one each for fielda, fieldb, and fieldc.
Or he needs to match the existing index:
fielda+fieldb+fieldc=a+b+c