I came across a tool that could recommend different ways to execute a given query. It would test the options for there relative speeds and highlight those that were faster than your original query.

While writing this I was checking for the product. SQLExpert by Leccotech http://www.leccotech.com

good luck