FOR XML Performance

• Hatim Ali

  Old Hand

  Points: 375

  More actions

  July 25, 2004 at 11:38 pm

  #108892

  Hi,

  I need to know the performance downsides of using For XML clause. Does SQL Server prepare an XML representation of data every time a query is executed ?? Is there any way of tuning the performance ??

  Also, which one is the most fastest  ??

  1. For XML Auto

  2. For XML Raw

  3. For XML Explicit

  Thanks in advance.

  Regards,

  Hatim Ali.

• Jonathan Stokes

  SSCrazy Eights

  Points: 9861

  More actions

  July 26, 2004 at 7:31 am

  #516076

  Check out this link - http://www.sql-server-performance.com/xml.asp

  This web site is by far the best for giving out best practice advice over a wide range of subjects.

  ---

  ------------------------------
  The Users are always right - when I'm not wrong!