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。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8520577/viewspace-2050408/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/8520577/viewspace-2050408/