sql 索引创建

–格式

–CREATE [索引类型] INDEX 索引名称
–ON 表名(列名)
–WITH FILLFACTOR = 填充因子值0~100
–GO

———————————————–

–实例

–USE 库名
–GO
IF EXISTS (SELECT * FROM SYSINDEXES WHERE NAME=’IX_TEST_TNAME’)–检测是否已经存在IX_TEST_TNAME索引
DROP INDEX FinanceLog.IX_TEST_TNAME–如果存在则删除

–创建索引
CREATE NONCLUSTERED INDEX IX_TEST_TNAME –创建一个非聚集索引
ON FinanceLog (status) –为TEST表的TNAME字段创建索引
–WITH FILLFACTOR = 1 –填充因子为30%
GO