Skip to Main Content
  • Questions
  • difference between sql tuning advisor and sql access advisor


Question and Answer

Connor McDonald

Thanks for the question, Amey.

Asked: June 26, 2009 - 6:47 am UTC

Last updated: November 14, 2017 - 1:34 am UTC

Version: 10g

Viewed 10K+ times! This question is

You Asked

After reading both "Sql Tuning advisor" and "sql access advisor" , getting little confused on
-- what is exact difference behind these advisors
-- which situation one can use one advisor over another

Please provide your guidance.


and Tom said...

The differences between them are listed here:

Link updated for 12.2:

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)


  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment


Indexes types recommended in SQL Tuning Advisor

Fábio Prado, December 12, 2016 - 4:51 pm UTC

Oracle docs says that SQL Tuning Advisor suggests indexes, but does not tell you what types of indexes. STA only suggest btree indexes?

Connor McDonald
December 13, 2016 - 2:15 am UTC

That is my understanding.

The decision on bitmap versus btree involves more than just sql statement being tuned (eg concurrency, transaction volume, etc) so that is a decision that will require human expertise

link is not working

Amir, November 10, 2017 - 11:14 am UTC

Connor McDonald
November 14, 2017 - 1:34 am UTC

Thanks, I've updated it.

More to Explore


Get all the information about database performance in the Database Performance guide.