Joel,
Just FYI, it is possible to get Rushmore to optimize a query using a compound index. If you change your WHERE clause to:
WHERE orders.CustNo+DTOS(orders.Date)=?cCustNo
you will get an optimized query (assuming your index tag is on CustNo+DTOS(Date).
>Finally, my views are "cooking". One last hickup which I just solved was the slowness of the query. I discovered that Rushmore was not kicking in because the index tag on my source file was custno+date, and the WHERE clause is WHERE orders.custno=?cCustno.
>
>Once I created a new index tag on custno (alone) the querys returned to lightning speed. I also used SYS(3054) to verify when Rushmore was helping.
>
>Thanks for helping point me down the right path. Now, I can proceed to the next hurdle. =Joel=