4.3 Tuning usp_RptFastestAnswers
This time I analyze usp_RptFastestAnswers, starting with only query changes: And in another session, I try to fix it with just index changes alone: And in yet another session, I don’t change the query or the indexes – I just try to reduce the stench of parameter sniffing by caching multiple plans.
To access this incredible, amazing content, you gotta get Mastering Parameter Sniffing – Live Classes + Instant Replay, 1 Year Access, Mastering Parameter Sniffing – Instant Replay Recordings Only, 1 Year Access or Recorded Class Season Pass, or log in if you already shelled out the cash.