hi,
I have never managed to fully optimise a query, and i'd really appreciate a few pointers as I find rushmore somewhat elusive

I have the following code:

SELECT Cm_tasks.*, Cm_vehicles.cmv_regno as regno, Cm_vehicles.cmv_pkey, Cm_vehicles.cmv_owned ;
FROM cm_tasks ;
LEFT OUTER JOIN cm_vehicles ;
ON  Cm_tasks.cmt_vehicle = Cm_vehicles.cmv_pkey ;
WHERE  Cm_tasks.cmt_propid == 2 ;
AND  Cm_tasks.cmt_due BETWEEN thisform.week1 and (thisform.week7 - 1) ;
ORDER BY Cm_tasks.cmt_due ;  
INTO CURSOR curPlanner  NOFILTER READWRITE 

thisform.week1 & 7 are date variables

I have indexes on all referenced fields

But when i test rushmore optimisation with SYS(3054) i get:

=SYS(3054,1,"cmemvar")

---------------------------
Microsoft Visual FoxPro
---------------------------

Using index tag Propid to rushmore optimize table cm_tasks
Using index tag Due to rushmore optimize table cm_tasks
Rushmore optimization level for table cm_tasks: partial
Rushmore optimization level for table cm_vehicles: none
---------------------------
OK
---------------------------

=SYS(3054,11,"cmemvar")

---------------------------
Microsoft Visual FoxPro
---------------------------

Using index tag Propid to rushmore optimize table cm_tasks
Using index tag Due to rushmore optimize table cm_tasks
Rushmore optimization level for table cm_tasks: partial
Rushmore optimization level for table cm_vehicles: none
Joining table cm_tasks and table cm_vehicles using index tag Pkey
---------------------------
OK
---------------------------

How can i improve this?


Thanks

John