CREATE XML INDEX |
Crée un index XML |
---|---|
Microsoft SQL Server |
Syntaxe
CREATE [ PRIMARY ] XML INDEX index_name ON object ( xml_column_name ) [ USING XML INDEX xml_index_name [ FOR { VALUE | PATH | PROPERTY } ] ] [ WITH ( xml_index_option [ ,...n ] ) ] [ ; ] object ::= { database_name.schema_name.table_name | schema_name.table_name | table_name } xml_index_option ::= { PAD_INDEX = { ON | OFF } | FILLFACTOR = fillfactor | SORT_IN_TEMPDB = { ON | OFF } | IGNORE_DUP_KEY = OFF | DROP_EXISTING = { ON | OFF } | ONLINE = OFF | ALLOW_ROW_LOCKS = { ON | OFF } | ALLOW_PAGE_LOCKS = { ON | OFF } | MAXDOP = max_degree_of_parallelism } |
Crée un index XML |
CREATE XML INDEX index_name ON table_object ( xml_column_name ) USING XML INDEX sxi_index_name FOR ( xquery_or_sql_values_path ) [WITH ( index_options )] table_object ::= { database_name.schema_name.table_name | schema_name.table_name | table_name } xquery_or_sql_values_path::= path_name path_name ::= chaîne de caractères littéral xmlnamespace_list ::= xmlnamespace_item [, xmlnamespace_list] xmlnamespace_item ::= xmlnamespace_uri AS xmlnamespace_prefix index_options ::= ( | PAD_INDEX = { ON | OFF } | FILLFACTOR = fillfactor | SORT_IN_TEMPDB = { ON | OFF } | IGNORE_DUP_KEY = OFF | DROP_EXISTING = { ON | OFF } | ONLINE = OFF | ALLOW_ROW_LOCKS = { ON | OFF } | ALLOW_PAGE_LOCKS = { ON | OFF } | MAXDOP = max_degree_of_parallelism ) |
Index XML sélectif |
Description
Cette instruction permet de créer un index XML dans une table spécifié.
Dernière mise à jour : Vendredi, le 19 Juin 2020