Sample Header Ad - 728x90

Is my query having Parameter Sniffing performance issue

1 vote
2 answers
281 views
Is my query having Parameter Sniffing performance issue ? I have kept my non-clustered index suggested by query execution plan, but still I have doubts whether this is parameter sniffing, or something else. Please check below query: declare @orgid int=22, @salesperson int=0 select pd.col1,dd.col1 from t1 pd inner join (select max(doId) doid,personId from t2 where productId=99 and personId>0 and effectDate IS NOT NULL group by personId) d on pd.personId=d.personId join t2 dd on d.doid=dd.doId join (select max(requestId) requestid,doId from t3 group by doId ) p on dd.doId=p.doId join t3 pp on p.requestid=pp.requestIdjoin person prn on cp.personId=prn.personId where pd.organizationId=@orgId and (@salesperson=0 or cp.personId=@salesperson) order by pd.patientName Will this line create an issue? (@salesperson=0 or cp.personId=@salesperson)
Asked by coder rock (13 rep)
Nov 22, 2024, 12:14 AM
Last activity: Nov 24, 2024, 04:09 PM