I'm trying to understand why and how XQuery queries can be optimized.
I've found a case that I find quite strange:
I've got property,value,path and primary index on my xml column, and also a schema so that the integer values are typed
This query is slow'ish and needs a nested join.
(the  on the property path seems to cause this)
View Complete Post