1
Reply

What is SQL access advisor in Oracle?

Sapna Malik

Sapna Malik

Apr 22, 2011
4k
0

    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.

    Sapna Malik
    April 22, 2011
    0