I work on sql server 2017 i face issue when run simple query it take 32 second to run two rows
so it is very slow according to number of rows returned and size of row not big
my execution plan is
https://www.brentozar.com/pastetheplan/?id=HyaIx0I6Y
script table
What I have tried:
CREATE TABLE [Parts].[TradeCodeControl](
[TradeCodeControlID] [int] IDENTITY(1,1) NOT NULL,
[VersionYear] [int] NULL,
[Version] [float] NULL,
[CodeTypeID] [int] NULL,
[RevisionID] [bigint] NULL,
[Code] [varchar](20) NULL,
[ZPLID] [int] NULL,
[ZfeatureKey] [bigint] NULL,
[ZValue] [nvarchar](2500) NULL,
[ZfeatureType] [nvarchar](200) NULL,
[Comment] [nvarchar](3000) NULL,
[ModifiedDate] [datetime] NULL,
[CreatedDate] [datetime] NOT NULL,
[Modifiedby] [int] NULL,
[CreatedBy] [int] NULL,
[OrderSequence] [tinyint] NULL,
CONSTRAINT [PK__TradeCod__49C7EB212E609428] PRIMARY KEY CLUSTERED
(
[TradeCodeControlID] 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 ON
GO
ALTER TABLE [Parts].[TradeCodeControl] ADD CONSTRAINT [DF__TradeCode__Creat__2439A564] DEFAULT (getdate()) FOR [CreatedDate]
GO