Home Forums SQL Server 2005 Administering SQL 2005 - SELECT query takes long time to retrieve RE: SQL 2005 - SELECT query takes long time to retrieve

  • Right click in your query window.

    click Include Actual Execution Plan

    when you execute the query next there will be an addition info that shows the Graphical query execution plan.

    you probably could benefit from a non-clustered index on your date field, or a covering index if the data types are not to large.

    here is a good tutorial on query optimization.

    http://www.simple-talk.com/sql/performance/execution-plan-basics/