https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms187886(v=sql.105)?redirectedfrom=MSDN
Transact-SQL Statements That Produce Showplans | Microsoft Learn
sql statementstransactproducemicrosoftlearn
https://learn.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms189298(v=sql.105)?redirectedfrom=MSDN
XML Showplans | Microsoft Learn
xmlmicrosoftlearn