SQL Optimization Workflow
The SQL optimization workflow ensures that your SQL statements perform optimally in your database environment.
| Procedure | Description |
|---|---|
| Optimize SQL Statements |
The SQL Optimizer uses artificial intelligence to generate alternatives with unique execution plans for problematic SQL statements. SQL Optimizer generates the alternatives by analyzing SQL statement syntax and database structure. Optimize SQL Statements |
| Test Run SQL |
The Test Run SQL function tests the performance of each alternative SQL Optimizer generates. This provides execution times for each alternative to determine the best statement for your database environment. Test Run SQL Alternatives |
| Compare SQL Alternatives |
The Compare feature displays details for two SQL statements side-by-side. You can compare an alternative to the original SQL statement or compare two alternatives. |
| Generate Reports |
The Report feature creates a SQL resolution report after you complete the optimization process. |