2
Answers

high cost index seek when analysis no cluster index How to solve ?

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]
SQL

Answers (2)

2
Photo of alice yang
NA 722 117 8y
Hello,
 
You can also use Free Spire.PDF(https://www.e-iceblue.com/Introduce/free-pdf-component.html) to achieve the same task.
 
Refer to below link:
https://www.e-iceblue.com/Tutorials/Spire.PDF/Spire.PDF-Program-Guide/Page-Setting/How-to-rotate-the-PDF-file-in-C.html  
Accepted
1
Photo of Mohamed Abedallah
NA 852 142 8y
According to the following dissection this issue seems to be working using iTextSharp v4.1:
http://stackoverflow.com/questions/10040161/itextsharp-landscape-document
 
Alternatively, you can take a look at LEADTOOLS Rotate functions to rotate your PDF file.
https://www.leadtools.com/help/leadtools/v19/dh/l/leadtools~leadtools.imageprocessing.rotatecommand.html
 
Disclaimer: I work for the company that created this library.
0
Photo of Satyaprakash Samantaray
56 29.2k 10.3m 8y
Thanks guys for answering my query.