• I dont think FOR XML will give you better performance. FOR XML may not be used as a means to increase performance. It is usually used when an XML output need to be passed to the calling application.

    If you have a slow running query, you should look at the execution plan to see what makes the query slow. The execution plan might tell what is causing the problem.

    .