>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"
>
There's nothing to optimize here. By the time the GROUP BY is executed, the engine is working with intermediate results.
Tamar