Here's a level zero introduction to tuning queries. I go over execution plans, sp_help, and clustered primary key indexes.