In Optimize Indexes, how do you define SQL that would be tuned by SQL Optimizer for Oracle? And what is a SQL Workload?
In Optimize Indexes, you can select the source of SQL Workload from
1. AWR
2. Foglight PA Repository
3. SGA
4. Scan Code
There is an additional filter available to define the SQL you want to tune.
For example an application can have a number of different yet related SQLs running. Some may run concurrently while some may interfere with each other. SQL Workload contains these SQLs as well as other relevant information such as timing, sequence and metrics.
As mentioned in the Optimize Indexes home, you use this module for a group of SQL statements and SQL Workloads. For single SQL statement, you should use Optimize SQL module.
