Answer
SQL Server caches execution plans for reuse.
Parameter sniffing occurs when a cached plan works well for one parameter but poorly for another due to data skew.
Want to bookmark, take notes, or join discussions?
Sign in to access all features and personalize your learning experience.
Source: SugharaIQ