Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mikael Eriksson Parameter sniffing RE: Parameter sniffing
Carlo Romagnano
SSC-Insane
Points: 22601
More actions
October 17, 2013 at 1:32 am
#1659142
palotaiarpad (10/17/2013)Is it a useful knowledge?
palotaiarpad (10/17/2013)
Yes, it is.
Sometimes, store procs run slow because of parameters sniffing and obsolete query plan.
If you recompile, store procs may run better.