I work on sql server 2014 i have issue on my execution plan below
index seek is high 57 what this mean and how to solve it
and how mean hash match inner join 40
can any one help me
table script as below :
CREATE TABLE [Parts].[Nop_PartsFamilyAttribute]( [PartFamilyAttributeID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [PartFamilyID] [int] NOT NULL, [Key] [int] NOT NULL, [Value] [nvarchar](2200) NULL, [CreatedDate] [datetime] NULL, [CreatedBy] [int] NULL, [ModifiedDate] [datetime] NULL, [Modifiedby] [int] NULL, [DeletedDate] [datetime] NULL, [DeletedBy] [int] NULL, CONSTRAINT [PK_Nop_PartsFamilyAttribute30] PRIMARY KEY CLUSTERED ( [PartFamilyAttributeID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Customer], CONSTRAINT [UK_PartFamilyID_Key30] UNIQUE NONCLUSTERED ( [PartFamilyID] ASC, [Key] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [Customer] ) ON [Customer]