You won't get optimization with the HAVING clause because that has to be processed after the whole SELECT query is done.


>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.