怎样在联合主键上建立索引
我们建立了如下的一张表,当数据达到100W以上时,插入速度会变得非常的慢,请问大家有什么好的建议吗?谢谢!
CREATE TABLE [dbo].[TBL_TEST](
[Field1] [varchar](8) NOT NULL,
[Field2] [bigint] NOT NULL,
[Field3] [varchar](max) NULL,
[Field4] [int] NULL,
[Field5] [varchar](50) NULL,
[Field6] [datetime] NOT NULL CONSTRAINT [DF_TBL_TEST_CreateDate] DEFAULT (getdate()),
[Field7] [varchar](50) NULL,
[Field8] [datetime] NULL,
CONSTRAINT [PK_TBL_TEST] PRIMARY KEY CLUSTERED
(
[Field2] ASC,
[Field1] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]