Optim query Tuner provides a series of advisors to automate the query tuning by giving recommendations, which you can review and implement directly from the product to resolve a performance issue.

This section illustrates how the query Tuner query annotation and access path graph can help you analyze access paths and SQL performance.

Launch into Optim Query Tuner (if installed) directly from SQL-related dashboards to do immediate tuning of problematic SQL, closing the loop on performance problem resolution.