XML indexes can be created on xml data type columns. They index all tags, values and paths over the XML instances in the column and benefit query performance. GeoPITS brings you the comprehensive details of XML indexing's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes | Yes | Yes |
| Version v2017 | Yes | Yes | Yes | Yes | Yes |
| Version v2016 | Yes | Yes | Yes | Yes | Yes |
| Version v2014 | |||||
| Version v2012 |
XML indexes can be created on xml data type columns. They index all tags, values and paths over the XML instances in the column and benefit query performance
You can find more details about this version here
Back to all features