SQL任务整理

--第一步
ALTER TABLE  [dbo].[Novel_BookViewLogTB] DROP constraint PK_NOVEL_BOOKVIEWLOGTB


--第二步
DROP INDEX Novel_BookViewLogTB.Novel_ViewLog_UserID_Index


--第三步
CREATE CLUSTERED INDEX [PK_Novel_ViewLog_UserID_Index] ON [dbo].[Novel_BookViewLogTB] ([UserID] ASC)


--第四步
ALTER TABLE Novel_BookViewLogTB ADD CONSTRAINT [PK_NOVEL_BOOKVIEWLOGTB] PRIMARY KEY ([ViewID] ASC)


--另外RssServer库中的tbloadhistory和tbloadhistory_text表的索引要重建

--另外是否考虑将软件检查更新的表，移到另一个库