SQL Access Advisor 与SQL Tuning Advisor
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1794009000346753857
In a nutshell - the tuning advisor
o suggests sql profiles
o gathering more or stale statistics
o indexes that might be VERY useful
o query rewrites
the access advisor
o suggests indexes that might be useful (a possibly different set than the tuning advisor above)
o materialized views
o materialized view logs
o partitions (in 11g on up only)
SQL Tuning Advisor针对于一个SQL给出优化建议，而SQL Access Advisor则是针对一组SQL。
In a nutshell - the tuning advisor
o suggests sql profiles
o gathering more or stale statistics
o indexes that might be VERY useful
o query rewrites
the access advisor
o suggests indexes that might be useful (a possibly different set than the tuning advisor above)
o materialized views
o materialized view logs
o partitions (in 11g on up only)
SQL Tuning Advisor针对于一个SQL给出优化建议，而SQL Access Advisor则是针对一组SQL。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8520577/viewspace-2050408/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
OCP考试题库-IZ0-052 第10题
下一篇：
IZ0-053 Q455
请登录后发表评论
登录
全部评论
