053-14 You have a very large table that your users access frequently. Which of the following advisor

最新推荐文章于 2019-08-11 08:08:35 发布

EVISWANG

最新推荐文章于 2019-08-11 08:08:35 发布

阅读量1.3k

点赞数

分类专栏： OCP 047

本文链接：https://blog.csdn.net/EVISWANG/article/details/49994967

版权

OCP 047 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

QUESTION 14
You have a very large table that your users access frequently. Which of the following advisors will
recommend any indexes to improve the performance of queries against this table?
A. The Automatic Memory Manager (AMM)
B. The SQL Tuning Advisor
C. The Segment Advisor
D. The SQL Access Advisor
Correct Answer: D
Section: (none)

Explanation

The SQL Access Advisor analyzes all SQL running during a given time period and recommends indexes
and materialized views to improve the overall performance of the database.
A is incorrect because there is no such advisor as the Automatic Memory Manager.

B is incorrect because the SQL Tuning Advisor looks only at a single SQL statement and provides recommendations.

C is incorrect because the Segment Advisor recommends segment shrink when table and index segments are
heavily fragmented.