先试 With (Online=On),若提示索引名存在,则 With (Online=On,Drop_Existing=On)
例如:
CREATE NONCLUSTERED INDEX IX_Product_IsTrad_IsBlack_IsCheck_Include_AccountID ON [dbo].[Product] ([IsTrad],[IsBlack],[IsCheck]) INCLUDE ([AccountID]) With (Online=On) GO