• As was stated all queries have an Execution Plan. Generating an Estimated Execution Plan for a query is one of the steps the Database Engine must do for all queries. In addition to Estimated plans there is also the concept of an Actual Execution Plan. You can start here to see a graphical representation of each type of Execution Plan:

    Displaying Graphical Execution Plans (SQL Server Management Studio) - SQL Server 2005

    Begin here to start learning about what execution plans are and how to read them:

    Execution Plan Basics (11 May 2008) by Grant Fritchey[/url]

    View the execution plans (estimated and actual) for one of your queries. Post a new thread if you have further questions.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato