Creates a new secondary selective XML index on a single path that is already indexed by an existing selective XML index. You can also create primary selective XML indexes. For information, see Create, Alter, and Drop Selective XML Indexes.
Applies to: SQL Server (SQL Server 2012 through current version), SQL Database Update (preview), (Get it).
Is the name of the new index to create. Index names must be unique within a table, but do not have to be unique within a database. Index names must follow the rules of identifiers.
Is the table that contains the XML column to index. You can use the following formats:
Is the name of the XML column that contains the path to index.
USING XML INDEX sxi_index_name
Is the name of the existing selective XML index.
FOR ( <xquery_or_sql_values_path> )
Is the name of the indexed path on which to create the secondary selective XML index. The path to index is the assigned name from the CREATE SELECTIVE XML INDEX statement. For more information, see CREATE SELECTIVE XML INDEX (Transact-SQL).