Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are

Post by answerhappygod »

Your database supports a mixed workload. In an application, multiple complex queries with functions and expressions are executing. You want to analyze the queries that are currently cached in the library cache to receive recommendations about the usage of indexes and materialized views.What should you do to achieve this? (Choose the best answer.)

A. Create an STS for the queries cached in the library cache and submit it as an input to SQL Tuning Advisor.
B. Create an STS for the queries cached in the library cache and submit it as an input to SQL Access Advisor.
C. Capture the workload in an STS and submit to SQL Tuning Advisor for recommendations.
D. Create an STS for the queries cached in the library cache and submit it as an input to SQL Performance Analyzer.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply