XML: Ability to index selected attributes
We do not want to incur the penalty of index update for ALL attribute writes. Need to support both indexes on attribute value, as well as element + attribute value (the latter is needed for doing attribute-based searches within a subtree).
Upvotes: 2<=-=Aug 24 2006 2:36PM=-=>
Dear Dimitri thanks for your request. We will look into your request for one of the future releases.<=-=Apr 25 2014 2:13PM=-=>
The feature was implemented in SQL Server 2012:
Thanks again for the suggestion.
Jos de Bruijn – SQL Server PM