Will your upgrade to 26ai provide faster SQL? Here we will cover the features that are new to 26ai and how they will improve or maintain the SQL performance as you upgrade to the new version. We will cover the following items:
• Automatic SQL Tuning Sets (ASTS)
• Automatic PL/SQL to SQL Transpiler
• Automatic SQL Plan Management (ASPM)
• SPM add verified SQL Plan Baseline
• Staging Tables
• Real-Time SQL Monitoring Enhancements

Oracle 26ai has several new features specifically around SQL tuning. We will cover the details behind how the automated one’s work, and for manual items examples of how to use them.

Help understand how to make upgrade to 26ai less painful from SQL performance point, and what new features to look for to make your applications run faster.