So if I add the 3 index in my old code(table)...
INDEX ON DocId TAG DocId
INDEX ON CStatus TAG CStatus
INDEX ON TTOD(DDate)TAG DDAte

...and it say's
Rushmore optimization level for table MYTABLE: full

Can is say this is the best I can get in terms of speed?

Thanks again for the reply, I really appreciate the help that you give.