SentryOne Plan Explorer properties window

execution-plan

Does the SentryOne Plan Explorer have a properties window similar to SSMS. I see the tool tip window next to the operators in the execution plan but no properties option ?

Best Answer

If you right-click on the column header on any of the grids, there is an option called Column Chooser:

This exposes a panel that lists all the columns that are available in that grid. You can drag any of these onto any location in the grid. Here is an example from Top Operations, where both Predicate and Seek Predicates are available:

The really nice thing about the grids is that all operators are listed together. In SSMS, to compare some of the more obscure properties between two operators, you either have to flip between tooltips and/or properties panels, or take screen shots (ugh).

If you post your plan somewhere and describe which index seek you mean, I can show you how to make these properties front and center.

Related Solutions

Sql-server – Does SentryOne Plan Explorer work

I use it. It isn't malware.

On the SQL Server forums its one of three useful tools/SSMS plug-ins that are widely used (and thus implicitly reviewed) by the community.

SentryOne Plan Explorer
SSMS Tools Pack
Red Gate SQL Search

Sql-server – How Plan Explorer Group Operators in Query Columns Tab

At first, it looks like you've modified XML, because the query does not exactly match the plan.

At second, format your query like this

SELECT o2.Column1, 
       o2.Column2, 
       o1.Column3, 
       o1.Column4, 
       o1.Column5 
  FROM Object1 as o1, 
       Object2 as o2, 
       Object3 as o3 
 WHERE o1.Column3 = o3.Column6 
   AND o2.Column1 = o3.Column7 
   AND o3.Column8 between ? and ?
   and o3.Column7 < ?

At third, instead of having separate indexes on Column7 and Column8 (green and red seeks) you better create one index on Column7 + Column8 (green first) and have included Column6. That will help you to avoid Red Scan.

At fourth, (optional) you can create index on o1.Column3 with included columns o1.Column3, o1.Column4, o1.Column5

Best Answer

Related Solutions

Sql-server – Does SentryOne Plan Explorer work

Sql-server – How Plan Explorer Group Operators in Query Columns Tab

Related Question