当前位置:
数据库索引,你该了解的几件事
时间:2025-11-05 03:29:54 出处:IT科技阅读(143)

复制CREATE [UNIQUE] [CLUSTERED|NONCLUSTERED] INDEX <indexname> ON <tableorviewname>(<columnname> [ASC|DESC] [,数据...n]) INCLUDE (<columnname> [, ...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 }] 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.
分享到:
温馨提示:以上内容和图片整理于网络,仅供参考,希望对您有帮助!如有侵权行为请联系删除!