Display Execution plan on SQL 2008 R2

Posted on 2014-08-26
Last Modified: 2014-09-10
Any idea how to display the actual execution plan on SQL 2008 R2 ? I have clicked the "Include Actual Execution Plan" icon under SQL Management Studio but  can't see any execution plan after running the query.

Attached is the estimated execution plan for a query. Base on the information, does it mean it use index rather than table scan. What will it be displayed if the query use Table scan to retrieve the result ? How can I tell from the execution plan result whether the query is efficient or not.

Question by:AXISHK
    LVL 29

    Expert Comment

    You should have an extra tab called "execution plan" after the query has finished running
    LVL 29

    Assisted Solution

    Yes it is scanning the index not the table. If there were no index it would show table scan.
    Here is a good article on understanding them.
    Be aware that any advice given for index creation/tuning will be based on the query/workload supplied and does not take other factors into consideration such as who/what else is using the tables and the ratio of queries to data modification
    LVL 47

    Accepted Solution

    Table Scan will look like this:table scan image
    It is preferable when providing execution plans to use XML
    see: Save an Execution Plan in XML Format

    and attach as a .sqlplan file (it's an allowed suffix at EE)

    If you don't already have it there is a free utility for reading execution plans  that is well worth the effort!
    (there is also a pro version, but I'm happy with the freebie)

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now