SET DELETED ON?
if SET DELETED is ON you always can have Partial result, but with these 3 indexes the query will run faster than just with one.
>Boris,
>
>Copying, pasting and executing your expression gave me this result.
>
>---------------------------
>Microsoft Visual FoxPro
>---------------------------
>
>SELECT count(*) FROM MYTABLE WHERE MYTABLE.docid = 1 AND MYTABLE.cstatus <> "XXX" AND BETWEEN(TTOD(MYTABLE.ddate), tDateFrom, tDateTo) GROUP BY MYTABLE.caddress INTO ARRAY laCount
>Using index tag Docid to rushmore optimize intermediate result
>Using index tag Cstatus to rushmore optimize intermediate result
>Using index tag Ddate to rushmore optimize intermediate result
>Rushmore optimization level for intermediate result: partial
>---------------------------
>OK
>---------------------------
>
>It still saying partial, am I missing something here?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.