SQL Server索引创建

创建索引

在了解了不同索引类型后，下面开始介绍如何使用T_SQL创建索引:

CREATE INDEX命令既可以创建一个改变表的物理顺序的聚集索引，也可以创建提高查询性能的非聚集索引。语法如下：

CREATE [UNIQUE] [CLUSTERED | NONCLUSTERRED]

INDEX index_name ON {table | view }(column ASC | DESC [,…n])

[ INCLUDE ( column_name [ ,…n])]

[with

(

PAD_INDEX={ON | OFF}

| FILLFACTOR =fillfactor

| SORT_IN_TEMPDB={ ON | OFF}

| IGNORE_DUP_KEY ={ ON | OFF}

| STATISRICS_NORECOMPUTE ={ ON | OFF}

| DROP_EXISTING = { ON | OFF}

| ONLINE ={ ON | OFF}

| ALLOW_ROW_LOCKS ={ ON | OFF}

| ALLOW_PAGE_LOCKS={ ON | OFF}

| MAXDOP =max_degree_of_parallelism

) [,…n] ]

UNIQUE: