Sapna Malik
What is SQL access advisor in Oracle?
By Sapna Malik in Databases & DBA on Apr 22 2011
  • Sapna Malik
    Apr, 2011 22

    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.

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS