Sqlserver列多批量插入慢的解决方案

下载次数 0 次 访问量441 次

把建表语句WITH()删掉就快了 有些人的建表语句是这样的 CONSTRAINT [PK_MEB_DISCOUNTSTOREVALUE] PRIMARY KEY CLUSTERED 
(
[DiscountID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO

网友评论

发表评论

欢迎评论哦!