Interested in how SQL Server 2005 indexes XML data
In SQL server 2005 there are a number of extra restrictions imposed on the size of keys in tables when using XML indexes.
John has a good post on what they are and why. He also does some interesting stuff with the new system tables so whow you waht has been created when you index an XML column
http://blogs.msdn.com/jgalla/archive/2005/08/18/453189.aspx
-