XPath expression for XQuery may cause high subtree cost

(Jan Novak) There are a few ways how to write Xpath expression. Not every expression may return expected data. Here is a review and Subtree cost in execution plan (SQL Server 2008 R2, 64bit) for each tested method. Xml contains 100 nodes, some of them are empty:

Read More - Register for Free Membership