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.