Home Forums SQL Server 2008 T-SQL (SS2K8) INSERT/SELECT from xml.nodes very slow RE: INSERT/SELECT from xml.nodes very slow

  • May 12, 2014 at 8:50 am

    #1712712

    Q.E.D.

    I added this weird line after the FROM clause and now results are immediate!

    OPTION ( OPTIMIZE FOR ( @xml = NULL ) )