Through SQL Optimizer, Toad for Oracle Xpert Edition can also generate index creation options based on continuous database SQL execution workload. It scans SQL and PL/SQL code, identifies potential performance issues and, if better-performing SQL alternatives exist, it generates the replacement code for immediate implementation into the code base.
SQL Optimizer automates the validation of SQL and PL/SQL to ensure the best possible performance. This is accessible through the Toad Editor’s Auto Optimize SQL feature for quick and simple single-statement optimization or separately through SQL Optimizer for Oracle. Toad for Oracle Xpert Edition includes all of the features in Toad for Oracle Professional Edition, plus integrated SQL and PL/SQL performance tuning.
0 kommentar(er)
