Hi,

I have a query which has inner joins on 10 tables and the result is an XML.

I would like to know that in terms of performance which is better. FOR XML AUTO or FOR XML Explicit.

It will be great if you can point out some facts/perf figures as well.