>> If you have keyword DISTINCT in your SQL, this SQL would be non-optimizable by Rushmore.
>
>Are you sure? I can't confirm that. A quick test of simple queries including DISTINCT shows full optimization. The DISTINCT clause would slow things down some, but it is often necessary.
I think, I could be wrong. I seem to recall that DISTINCT clause is not Rushmore optimizable, but I was not able to found this mentioned in the Help. Perhaps my memory is not clear enough :)
If it's not broken, fix it until it is.
My Blog