<p>ALTER INDEX 命令在其用来做什么方面多少有些欺骗性。截至现在,ALTER命令总是与修改对象的定义有关。例如,ALTER(修改)表以添加或禁用约束和列。ALTER INDEX是不同的——该命令与维护有关,而与结构完全不相干。如果需要修改索引的组成,那么只能DROP(删除)然后CREATE(创建)索引,或者用DROP_EXISTING = ON选项CREATE(创建)并使用索引。</p>

ALTER INDEX 的语法类似于下面这样:

ALTER INDEX {<name of="" index=""> | ALL}
	ON 
	{REBUILD
	[[WITH (
		[PAD_INDEX = {ON | OFF}]
		|[[,] FILLFACTOR = <fillfactor>
		|[[,] SORT_IN_TEMPDB = {ON | OFF}]
		|[[,] IGNORE_DUP_KEY = {ON | OFF}]
		|[[,] STATISTICS_NORECOMPUTE = {ON | OFF}]
		|[[,] ONLINE = {ON | OFF}]
		|[[,] ALLOW_ROW_LOCKS = {ON | OFF}]
		|[[,] ALLOW_PAGE_LOCKS = {ON | OFF}]
		|[[,] MAXDOP = <max degree="" of="" parallelism="">
	)]
	| [PARTITION = <partition number="">
		[WITH (<partition rebuild="" index="" option="">
		[, ...n])]]]
	| DISABLE
	| REORGANIZE
		[PARTITION = <partition number="">]
		[WITH (LOB_COMPACTION = {ON | OFF})]
	| SET ([ ALLOW_ROW_LOCKS = {ON | OFF}]
		| [[,] ALLOW_PAGE_LOCKS = {ON | OFF}]
		| [[,] IGNORE_DUP_KEY = {ON | OFF}]
		| [[,] STATISTICS_NORECOMPUTE = {ON | OFF}]
		)
	}[;]

以下是一个示例:

USE AdventureWorks;

ALTER INDEX PKSalesOrderDetailSalesOrderID_SalesOrderDetailID ON Sales.SalesOrderDetail REBUILD WITH (FILLFACTOR = 100)