Index, materialized view, and partitioning recommendations from Oracle's SQL Access Advisor — surfaces access path improvements from real workload captured in AWR.
Querying SQL Access Advisor…
Fetching tasks and recommendations from DBA_ADVISOR_*
🗂️
Select a connection and click "Fetch"
Reads SQL Access Advisor tasks from the last 30 days and their top recommendations. Requires Oracle Tuning Pack license.