As far as I know there are two ways of reading XML using SQL, either openxml or XQuery. There's a lot of debate on which is better or faster. Certainly, openxml makes the code easier to read. I know I can use XQuery and take advantage of the XML indexes in tables. I wanted to know if there is such possibility using openxml.