>Hi, is it possible to make Rushmore optimization work here:?
>
>Table1's PK expression is PKF1 + PKF2
>
>

>Select PKF1, PKF2, Count(1) as nDup from Table1 group by PKF1, PKF2 ;
>Having nDup > 1
>

>
>
>Do I have to add any WHERE clause or any tip to see Optimization:Full?
>
>
>Current result is "Optimization: None"
>
>Thanks.

VFP is not capable to optimize a GROUP BY query.

But if it is a PK, as can it have multiple records ?