Perfomance effect of using FOR XML[AUTO |EXPLICIT | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Perfomance effect of using FOR XML[AUTO |EXPLICIT

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.
How abouthttp://www.sql-server-performance.com/xml.asp link for reference.
HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>