Quest bought them out years ago. I'm not sure if it's related to the SQL Optimizer product that Quest has.
SQL Optimizer does do the alternative sql statements you mention and benchmarks the alternatives. You might want to see if they have a trial version to test.
Sue
I am not sure if I can buy a license for that. I went through their portal and I couldn't find that. I think I might have to call their sales team for this. Any other alternatives?
I just did a search on: SQL Optimizer Quest
and the download link was right there.
SQL Optimizer for SQL Server - Download Software
And then when I pulled out the word Quest and just had SQL Optimizer, it provided links to other tools. You may want to try searching on that and trying some of those other options.
Sue
I tried creating a trial account but it says that I haven't purchased this product and need to contact customer service and there is no trial download available for this. I will have to speak to someone over there in order to get a trial link.