关于索引重建

alter table ZineCollection

add [Action] [int] NOT NULL CONSTRAINT [INX_ZineCollection_Action]  DEFAULT ((0))

 

//删除主键索引

ALTER TABLE ZineCollection DROP CONSTRAINT PK_ZineCollection 

 

 //创建主键索引

 

ALTER TABLE ZineCollection ADD CONSTRAINT PK_ZineCollection PRIMARY KEY ([uid],[ObjID],[ObjType],[Action])

 

 

//删除普通索引

 drop index PK_ZineCollection on ZineCollection 

// 创建普通聚集索引

CREATE CLUSTERED INDEX [PK_T_MyAttention] ON ZineCollection(UID,  Action)