This is easier than coding multiple DROP INDEX and CREATE INDEX statements.
这要比对多条DROPINDEX和CREATEINDEX语句进行编码更容易。
You can manually configure the number of processors that are used to run the DROP INDEX statement by specifying the MAXDOP index option.
可以通过指定MAXDOP索引选项来手动配置用于运行DROPINDEX语句的处理器数。
ON option so the DROP INDEX transaction does not block queries and modifications to the underlying data and associated nonclustered indexes.
ON选项,这样DROPINDEX事务就不会阻塞对基础数据和相关的非聚集索引的查询和修改。
Indicates that an object has been deleted; for example, by the DROP INDEX statement or the DROP TABLE statement.
指示已删除对象,例如已使用DROPINDEX语句或DROPTABLE语句删除。
The DROP INDEX statement does not apply to indexes created by defining PRIMARY KEY or UNIQUE constraints.
DROPINDEX语句不适用于通过定义PRIMARYKEY或UNIQUE约束创建的索引。这些约束是分别使用。
Also, DBCC DBREINDEX offers the advantage of more optimizations than individual DROP INDEX and CREATE INDEX statements.
此外,DBCCDBREINDEX提供了比单个DROPINDEX和CREATEINDEX语句具有更多优化性能的优点。
Index page deallocation during a DROP INDEX operation is always fully logged.
DROPINDEX操作期间将完整记录索引页的释放操作。
The DROP INDEX Transact-SQL statement can be used to drop existing primary or secondary XML and non-XML indexes.
DROPINDEXTransact-SQL语句可用于删除现有的主(或辅助)XML索引和非XML索引。