ahmed elbarbary

ahmed elbarbary

  • 950
  • 1.6k
  • 128.5k

when no rows insert it take 4 minute for insert 0 rows why and how t ?

Nov 18 2021 10:20 PM

I work on sql server i face issue when insert data it take 4 minute for insert 0 rows
why
and How to solve this problem ?
execution plan as below :

execution plan

first table

so how to solve this issue please

CREATE TABLE [Parts].[TradeCodes]([TradeCodesID] [int] IDENTITY(1, 1) NOT NULL, [PartID] [int] NOT NULL, [Code] [varchar](20) NOT NULL, [CodeTypeID] [int] NOT NULL, [SourceTypeID] [bigint] NULL, [RevisionID] [bigint] NULL, [ModifiedDate] [datetime] NULL, [CreatedDate] [datetime] NOT NULL, [Modifiedby] [int] NULL, [CreatedBy] [int] NULL, [PartLevel] [tinyint] NULL, [ZPLID] [int] NULL, [MappingDoneFlag] [int] NOT NULL, [MappingValueId] [int] NOT NULL, CONSTRAINT [PK__TradeCod__FEFAF27527F7A1C3] PRIMARY KEY CLUSTERED ([TradeCodesID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = 
ON, ALLOW_PAGE_LOCKS = 
ON) 
ON [PRIMARY], CONSTRAINT [UC_PartCode] UNIQUE NONCLUSTERED ([PartID] ASC, [CodeTypeID] ASC, [PartLevel] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = 
ON, ALLOW_PAGE_LOCKS = 
ON) 
ON [PRIMARY]) 
ON [PRIMARY]GOSET ANSI_PADDING ONGOALTER TABLE [Parts].[TradeCodes] ADD CONSTRAINT [DF__TradeCode__Creat__215D38B9] DEFAULT (getdate()) FOR [CreatedDate]GOALTER TABLE [Parts].[TradeCodes] ADD DEFAULT ((0)) FOR [MappingDoneFlag]GOALTER TABLE [Parts].[TradeCodes] ADD DEFAULT ((0)) FOR [MappingValueId]GOCREATE TABLE [dbo].[TPLNewData]([PartID] [int] NOT NULL, [Code] [varchar](20) NULL, [CodeTypeID] [int] NULL, [RevisionID] [bigint] NULL, [ZPLID] [int] NULL) 
ON [PRIMARY]CREATE TABLE [dbo].[TradeCodesInsert]([TradeCodesID] [int] IDENTITY(1, 1) NOT NULL, [PartID] [int] NOT NULL, [Code] [varchar](20) NOT NULL, [CodeTypeID] [int] NOT NULL, [SourceTypeID] [bigint] NULL, [RevisionID] [bigint] NULL, [ModifiedDate] [datetime] NULL, [CreatedDate] [datetime] NOT NULL, [Modifiedby] [int] NULL, [CreatedBy] [int] NULL, [PartLevel] [tinyint] NULL, [ZPLID] [int] NULL, [FunctionName] [nvarchar](50) NULL, [MappingDoneFlag] [int] NOT NULL, [MappingValueId] [int] NOT NULL, [FeatureName] [nvarchar](500) NULL, [FeatureValue] [nvarchar](500) NULL, [FlagInsert] [int] NULL, CONSTRAINT [PK__TradeCod__FEFAF27527F7A1C3] PRIMARY KEY CLUSTERED ([TradeCodesID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = 
ON, ALLOW_PAGE_LOCKS = 
ON) 
ON [PRIMARY], CONSTRAINT [UC_PartCode] UNIQUE NONCLUSTERED ([PartID] ASC, [CodeTypeID] ASC, [PartLevel] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = 
ON, ALLOW_PAGE_LOCKS = 
ON) 
ON [PRIMARY]) 
ON [PRIMARY]GOSET ANSI_PADDING OFFGOALTER TABLE [dbo].[TradeCodesInsert] ADD CONSTRAINT [DF__TradeCode__Creat__215D38B9] DEFAULT (getdate()) FOR [CreatedDate]GOALTER TABLE [dbo].[TradeCodesInsert] ADD DEFAULT ((0)) FOR [MappingDoneFlag]GOALTER TABLE [dbo].[TradeCodesInsert] ADD DEFAULT ((0)) FOR [MappingValueId]
GO

 


Answers (2)