What is SQL access advisor in Oracle?
Sapna Malik
The SQL Access Advisor makes suggestions about indexes and materialized views which might improve system performance. The SQL access advisor uses this advisor to tune schema to a given SQL workload. The SQL access advisor identifies and helps resolve performance problems relating to the execution of SQL statements. It recommends materialized views, indexes, and materialized view logs to improve query response times.