Advanced SQL Developer — Hard
Key points
- OPTION (RECOMPILE) generates a new execution plan at runtime
- It uses actual parameter values to avoid parameter sniffing issues
- Helps prevent using a cached plan with incorrect parameters
Ready to go further?
Related questions