SHOWPLAN_TEXT ON vs SHOWPLAN_ALL ON

Question

what's the actual difference ? I can't see

Answer 1

Hi sakuraime,
The showplan_all contains the columns output by showplan_text, as well as other columns such as estimated rows, IO and CPU costs, Node Id, etc.
Set showplan_text on:

Set showplan_all on：

Please refer to SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL which might help.
Best Regards,
Amelia

=======================================

Please remember to Accept Answer and upvote the responses that resolved your issue.

Answer 2

Refer the below link for more details.
http://www.sqlbythebook.com/2016/12/28/showplan-options/

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped.
Blog
LinkedIn

Answer 3

SHOWPLAN_TEXT only gives you the "plan shape" and SHOWPLAN_ALL also gives you estimates (number of rows, for instance). But why mess about with these when we have XML? These haven't been improved on for two decades now!