SHOWPLAN_TEXT and SHOWPLAN_ALL commands for MS SQL. Where can I find a full description of how to work with them?

Question

SQL

Lately, I've had to work a lot with the results of query plans in text form (SET SHOWPLAN_TEXT ON). Prompt please, where it is possible to find the full description of text plans of requests which they issue?
ps: Many things are clear in meaning, but I really want to fully understand this, what and how it works.

Answer 1

www.simple-talk.com/sql/performance/execution-plan-basics/