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.