>>>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.
>
>Just double-checking... you removed the index on DELETED() too (if it existed)?

Yes, I removed the deleted index and I set deleted OFF just before I run the query.