Checkout the sixth part of my XML support and SQL Server article series here.

In this part, you will learn about XML indexes (primary and secondary), and how they can effectively improve xQuery performance. You will also learn how you can manage the XML indexes using SQL Server Management Studio.