>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.