Section courante

A propos

Section administrative du site

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