Section courante

A propos

Section administrative du site

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