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
script table
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]GOSET ANSI_PADDING ONGOALTER TABLE [Parts].[TradeCodeControl] ADD CONSTRAINT [DF__TradeCode__Creat__2439A564] DEFAULT (getdate()) FOR [CreatedDate]GO