The latest enhancements in SQL plan management
summary
Automatic SQL Plan Management detects execution plan drift and automatically repairs regressions by reinstating a proven prior plan stored in the Automatic SQL Tuning Set. It uses the evolve advisor to test candidate plans (background periodic verification in 19c) and adds foreground immediate repair in 23c so the running session can be fixed before the next execution. Feature ships on Autonomous Database/Exadata and can target only affected SQL without requiring pre-capture.
AI-written summary · about
chapters (5)
- 0:00Introduction to SPM
- 9:31Automatic SPM mechanisms
- 16:10Real-time enhancements in 23c
- 18:48Leveraging features manually
- 20:16Summary and resources
related talks
22mEmpowering SQL: Mastering Intelligent Query Processing in 20 Minutes
50mBuilt-in Intelligence with Azure SQL and SQL Server 2022
27mAutomating Data Management for All
49mPerformance Features in SQL Server and Azure SQL
53mBanishing Slow Queries with Intelligent Query Processing
24mAutomate Data Management with Autonomous Database- 22mEmpowering SQL: Mastering Intelligent Query Processing in 20 Minutes
20mDebate: Autotuning