See DB Optimizer automatically in seconds do the work that Jonathan does to diagram a query, gather the statistics, find the schema relations and analyze indexes, in other works, the work required to tune the query.
run query in multiple connections in a loop
profile databse to see impact
tune the query with SQL Tuner
then see the lower impact by running new query in the Load Editor and looking at results of profiling