Oracle performance tuning case studies with before/after and PLSQL scripts.
-
Updated
Sep 10, 2025
Oracle performance tuning case studies with before/after and PLSQL scripts.
SQL Server performance tuning case studies with before/after and T-SQL scripts.
Demonstrates the impact of parameter sniffing on execution plans and performance in SQL Server. Compares simple SPs, dynamic SQL, and OPTION(RECOMPILE to mitigate performance issues.
Add a description, image, and links to the parameter-sniffing topic page so that developers can more easily learn about it.
To associate your repository with the parameter-sniffing topic, visit your repo's landing page and select "manage topics."