关于proc索引的创建

 

USE [database]
GO
CREATE NONCLUSTERED INDEX IX_TableName_CloumnA_CloumnB
ON TableName ([CloumnA],[CloumnB])
INCLUDE(CloumnC)
WITH(ONLINE=ON)

 select ,update的字段、order by 、group by 放 Include。where条件中的放on

对于关联语句中的on，当有语句有where条件时放include，当没有where时放在on

USE [database]
GO
CREATE NONCLUSTERED INDEX IX_TableName_CloumnA_CloumnB
ON TableName ([CloumnA],[CloumnB])
INCLUDE(CloumnC)
WITH(ONLINE=ON，DROP_EXISTING = ON)

DROP_EXISTING = ON 删除与创建索引名称相同的索引，可用作对索引的修改