Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

sql access vs. tuning advisor question

Dude!Oct 29 2010 — edited Nov 27 2010

I'm trying to understand a question which is:

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?

a) SQL Tuning Advisor
b) SQL Access Advisor

I think the correct answer is a) tuning advisor, because it is for a particular SQL statement and it can also be configured to automatically create an index when it runs during the standard repeating maintenance job. However, the correct answer marked is b) Access Advisor. Which one is correct, and why?

Thanks!

This post has been answered by Seankool-Oracle on Nov 1 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 30 2010

Added on Oct 29 2010

#general-database-discussions

25 comments

900 views