691. You work in a data warehouse environment that involves the

分类: 英语题型 发布时间: 2023-12-01 12:13 浏览量: 0

691. You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache contains the ideal workload for analysis. You want to analyze only a few most resource-intensive statements. What must you do to receive recommendations on efficient use of indexes and materialized views to improve query performance?

A.Run the SQL Access Advisor.

B.Run the SQ; Tuning Advisor (STA).

C.Run the Automatic Workload Repository (AWR) report.

D.Run the Automatic Database Diagnostic Monitor (ADDM).

正确答案是A