Parameter Sniffing 1. replace parameters with local variables 2. WITH RECOMPILE SET STATISTICS IO ON SET STATISTICS IO OFF