Home Forums SQL Server 2012 SQL Server 2012 - T-SQL using cross apply to find different values trough xml files eficiency RE: using cross apply to find different values trough xml files eficiency

  • This is a very inefficient way of querying the XML, can you post a sample of the XML so we can help you out here?
    😎

    Jeff, I don't think an XML index would help much as the query is so inefficient, more like sprinkling sugar on cat food as our friend used to say.