Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
The index is designed to be used with xmlexists. It helps to decide whether a specific pattern is matched by a doc and where. Could you elaborate on the relational index?
I added more details. I assume that you looked at the query plan and noticed that the index wasn't used for the sort. Was it used at all? How big is your data set?
