Hi @ahmed salah
As far as i think, the 98% is relative figure. This is a cost as per total query flow and it does not co-relate with the time.
However, if this query is using Clustered Index and taking time, then you can create a Non-Clustered covering Index that contains all the columns needed to enhance the query.
Like this:
CREATE NONCLUSTERED INDEX [IDX_ChemicalID] ON [Parts].[FMDMaster] ([ChemicalID] ASC)
INCLUDE ([StrSubstance], [StrMass], [strCASNumber], [strHomogeneousMaterialName], [strHomogeneousMaterialMass])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
Best regards,
LiHong
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.