<p>CREATE INDEX 语句所做的事情与其听上去一样——用于在指定表或视图上基于声明的列创建索引。</p>
创建索引的语法如下:
CREATE [UNIQUE] [CLUSTERED|NONCLUSTERED] INDEX <index name> ON <table or view name>(<column name> [ASC|DESC] [, ...n]) INCLUDE (<column name> [, ...n]) [WITH [PAD_INDEX = {ON | OFF}] [[,] FILLFACTOR = <fillfactor>] [[,] IGNORE_DUP_KEY = {ON | OFF}] [[,] DROP_EXISTING = {ON | OFF}] [[,] STATISTICS_NORECOMPUTE = {ON | OFF}] [[,] SORT_IN_TEMPDB = {ON | OFF}] [[,] ONLINE = {ON | OFF}] [[,] ALLOW_ROW_LOCKS = {ON | OFF} [[,] ALLOW_PAGE_LOCKS = {ON | OFF} [[,] MAXDOP = <maximum degree of parallelism> ] [ON {<filegroup> | <partition scheme name> | DEFAULT }]