Reports information about an abstract plan.
sp_help_qplan id [, mode ]
is the ID of the abstract plan.
is the type of report to print, one of the following:
mode |
Information returned |
|---|---|
full |
The plan ID, group ID, and hash key, and the full query and plan text. |
brief |
The same as full, but only prints about 80 characters of the query and plan, rather than the full query and plan. This is the default mode. |
list |
The hash key, ID, and first 20 characters of the query and plan. |
Prints the brief abstract plan report:
sp_help_qplan 800005881
gid hashkey id ----------- ----------- ----------- 5 2054169974 937054374 query -------------------------------------------------------------------------- select type, avg(price) from titles group by type plan -------------------------------------------------------------------------- ( plan ( store Worktab1 ( i_scan type_price titles ) ) ( t_scan ( ...
Prints the full abstract plan report:
sp_help_qplan 784005824, full
If you do not supply a value for the mode parameter, the default is brief.
Any user can execute sp_help_qplan to see the abstract plan of a query that he or she owns. Only the System Administrator and the Database Owner can display an abstract plan owned by another user.
System procedures sp_find_qplan, sp_help_qpgroup
