• Query tuning is a complex art, but Grant Fritchey's book on execution plans is a good resource to start with. It's available as a free pdf here:

    http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2