移动端

  • 题王微信公众号

    题王微信公众号

    微信搜“题王网”真题密题、最新资讯、考试攻略、轻松拿下考试

单选题

Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?()

发布日期:2022-07-11

Your database supports a DSS workload that involve...
A

Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.

B

Run the Automatic Workload Repository Monitor (ADDM).

C

Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.

D

Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

标签: "暂无标签"

题王网让考试变得更简单

扫码关注题王,更多免费功能准备上线!