I am looking at the SQL server execution plan pane and I am not quite sure what "factors" I should be looking for when trying to optimize or revise sql code.
It is open ended question... So read the following articles... http://www.sql-server-performance.com/tips/query_execution_plan_analysis_p1.aspx http://www.simple-talk.com/sql/performance/execution-plan-basics/ http://sqlserverpedia.com/wiki/Examining_Query_Execution_Plans