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