Help improving SQL Server 2005 query execution time
If you post schema and query etc, that would be useful, in addition to the other 3 answers.

Some links anyway, from Simple-Talk. Good stuff.


Execution Plan Basics
Graphical Execution Plans for Simple SQL Queries
Understanding More Complex Query Plans