I can’t see Index Analysis

Meenak 2017-06-08 07:20:50

Can't see anything in Index analysis and TableI/O, Expression Parameters.

The rest I can see like Plan Tree, Join Diagram, Plan Diagram

Aaron Bertrand 2017-06-08 11:46:23
It doesn't look like you generated this plan from within Plan Explorer. In order to take advantage of the additional information we collect, you need to generate the plan inside Plan Explorer. (If you did generate it from Plan Explorer, what is the build number from Help / About, are any of the objects here partitioned, and are any of them views or synonyms that reference objects in another database?) As an aside, you have TOP 100 but no ORDER BY. Do you not care which 100 rows you get?