I would like to do Bulk Insert, but it takes a long time. My Idea is to disable Index on the table, to do INSERTs a little bit faster. But after that I get this error:
Error: The query processor is unable to produce a plan because the index
CRMD_MKTTG_TG_I~0
on table or view 'CRMD_MKTTG_TG_I
' is disabled.
I am generating my table with this script:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [CRMD_MKTTG_TG_I](
[CLIENT] [nvarchar](3) NOT NULL,
[GUID] [varbinary](16) NOT NULL,
[TG_GUID] [varbinary](16) NULL,
[BP_GUID] [varbinary](16) NULL,
[BP_ORG] [nvarchar](2) NOT NULL,
[BP_DEL] [nvarchar](1) NOT NULL,
[REL_GUID] [varbinary](16) NULL,
[RELATIONSHIP] [nvarchar](6) NOT NULL,
[TYPE_BP_GUID] [nvarchar](1) NOT NULL,
[TYPE_REL_GUID] [nvarchar](1) NOT NULL,
[ROW_NUMBER] [int] NOT NULL,
CONSTRAINT [CRMD_MKTTG_TG_I~0] PRIMARY KEY CLUSTERED
(
[CLIENT] ASC,
[GUID] 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
SET ANSI_PADDING OFF
GO
any idea?
[CRMD_MKTTG_TG_I~0]
is a clustered index. If you disable it, you can't access to the data (select, insert, update, delete data).
Read Disable Indexes and Constraints:
In this case, you can only:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With