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
Last activity: Nov 24, 2024, 04:09 PM