CREATE INDEX |
Crée un index |
---|---|
Microsoft SQL Server |
Syntaxe
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name ON object ( column [ ASC | DESC ] [ ,...n ] ) [ INCLUDE ( column_name [ ,...n ] ) ] [ WHERE filter_predicate ] [ WITH ( relational_index_option [ ,...n ] ) ] [ ON { partition_scheme_name ( column_name ) | filegroup_name | default } ] [ FILESTREAM_ON { filestream_filegroup_name | partition_scheme_name | "NULL" } ] [ ; ] object ::= { database_name.schema_name.table_or_view_name | schema_name.table_or_view_name | table_or_view_name } relational_index_option ::= { PAD_INDEX = { ON | OFF } | FILLFACTOR = fillfactor | SORT_IN_TEMPDB = { ON | OFF } | IGNORE_DUP_KEY = { ON | OFF } | STATISTICS_NORECOMPUTE = { ON | OFF } | STATISTICS_INCREMENTAL = { ON | OFF } | DROP_EXISTING = { ON | OFF } | ONLINE = { ON | OFF } | RESUMABLE = { ON | OFF } | MAX_DURATION = time [MINUTES] | ALLOW_ROW_LOCKS = { ON | OFF } | ALLOW_PAGE_LOCKS = { ON | OFF } | OPTIMIZE_FOR_SEQUENTIAL_KEY = { ON | OFF } | MAXDOP = max_degree_of_parallelism | DATA_COMPRESSION = { NONE | ROW | PAGE } [ ON PARTITIONS ( { partition_number_expression | range } [ , ...n ] ) ] } filter_predicate ::= conjunct [ AND conjunct ] conjunct ::= disjunct | comparison disjunct ::= column_name IN (constant ,...n) comparison ::= column_name comparison_op constant comparison_op ::= { IS | IS NOT | = | <> | != | > | >= | !> | < | <= | !< } range ::= partition_number_expression TO partition_number_expression |
Description
Cette instruction permet de créer un index relationnel dans une table ou une vue.
Dernière mise à jour : Vendredi, le 19 Juin 2020