Hi Dawa:

Thanks again for your response.

I think that the rushmore optimization sys function is just stating "none" b/c there isn't filtering going on within the tables themselves. In reading about this in the hacker guide to vfp 7.0, it states that if you're selecting all the data from the tables then this sys function will result in "none".

to test this, i used the following:

CREATE VIEW view_memolist as;
select pt_number, memo_date, memo_id, type, ;
t_memo.memo, t_memo.type_number from ;
t_memo, memo_type where;
t_memo.type_number = memo_type.type_number ;
AND t_memo.type_number <> 0;
AND memo_type.type_number <> 0;
INTO CURSOR cursor_test1

now, i get full optimization. however, i don't think that adding these two lines makes an impact. i think it just changes the result of the sys function. if you disagree, let me know.

nevertheless, it still doesn't explain why the query would be faster in the vfp8.0 window rather than in my application by almost 10x. Any ideas on that? Thanks.

Paul