>>Dan-
>>
>>I see Alex and Sergey's posts and your replies. I don't see where you posted the results of SYS(3054,1), which is the first thing I'd check when optimizing a SQL-Select just because otherwise I'm not confident of what Rushmore is doing.
>>
>>I don't know what your situation is, but I recently improved a situation by taking off the !DELETED() filter off the PK index, and removed the DELETED() tag. Selects went from seconds to sub second.
>
>The results are Full Optimization. I removed the all the offensive indexes that returns the majority of the records.

I gather you mean you did this and the times are still slow? Are you running these queries locally or over a LAN?