Retrieving the estimated plan is just telling SQL Server to return the execution plan without actually executing it, helpful in debugging. From MSSM (Microsoft SQL Server Management tool), select an ...

To view query plan or missing indexes, call static QueryPlanVisualizer.DumpPlan(query) method or call DumpPlan extension method on an IQueryable instance. You will also need to add ...