I know how VFP uses rushmore in a where clause (reasonably well), but I don't know what it does in more complex sql statements.

What indexes would be relevant for the following query?


SELECT order_num, item_code, sum(quantity) as tot_qty ;
from kit_orditems ;
group by order_num, item_code ;
having count(*) > 1 ;
into CURSOR dups

There are already indexes on order_num and item_code. Do the group by fields (or expressions) need to have indexes?

How about the having clause?


TIA