Use sp_help_qplan to report on individual abstract plans. It provides three types of reports that you can specify: brief, full, and list. The brief report prints only the first 78 characters of the query and plan; use full to see the entire query and plan, or list to display only the first 20 characters of the query and plan.
This example prints the default brief report:
sp_help_qplan 588529130
gid hashkey id
----------- ----------- -----------
8 1460604254 588529130
query
---------------------------------------------------------------
select min(price) from titles
plan
---------------------------------------------------------------
(plan
(i_scan type_price titles)
()
)
(prop titles
(parallel ...
A system administrator or database owner can use sp_help_qplan to report on any plan in the database. Other users can view only the plans that they own.
sp_help_qpgroup reports on all plans in a group. See “Getting information about a group”.
