The attached image shows Execution Plan/ Client Statistics for this query:
select distinct AnalyteCode, Analyte
Order By AnalyteCode
Q1: What indexes would you recommend to be added to improve its performance?
Maybe: CREATE INDEX index_Analyte_LabAnalyteDa
ta ON LabAnalyteData (Analyte
But what if I add the following index; is there still a need to add additional indexes?
CREATE INDEX index_FK_IDinAccess_LabAna
lyteData ONLabAnalyteData (IDinAccess, AnalyteCode, Analyte, ConcentrationLevelUnit
Q2: On the Client Statistics, what do Trial 1, Trial 2, and Trial 3 mean?