I want to sort execution plan XML by Estimated Operator Cost, but the problem is:
SQL Server execution plan has the "Estimated Operator Cost" entry in UI:
...but that value is missing from the XML output.
There are several suggestions on how to sort the XML, like:
- SQL Server – Find the most expensive operations in Execution plans by Mladen Prajdić.
- How to find the most expensive operation in an execution plan on the old MSDN forums.
But neither are even close to what I'm having, as the "Estimated Operator Cost" seems to be a super complicated calculation.
Is there any solution to this problem please?