Bad Wrap
When people hear the words “parameter sniffing”, there’s almost a universally bad reaction. They lose their minds and start raving about how to “fix” it.
- Recompiling everything
- Using optimize for unknown hints
- Using local variables
- Clearing the plan