Which three actions would you take to improve the perfo…

Your database supports a DSS workload. In an application, a few complex queries that contain multiple
functions and expressions are using materialized views. You notice that some queries are performing poorly
because they are not benefiting from query rewrites.
Which three actions would you take to improve the performance of queries? (Choose three.)

Your database supports a DSS workload. In an application, a few complex queries that contain multiple
functions and expressions are using materialized views. You notice that some queries are performing poorly
because they are not benefiting from query rewrites.
Which three actions would you take to improve the performance of queries? (Choose three.)

A.
Create an SQL Tuning Set (STS) and submit as input to the SQL Access Advisor to generate
recommendations about query rewrite and fast refresh for materialized views.

B.
Use the DBMS_MVIEW.EXPLAIN_REWRITE procedure to analyze why a query failed to rewrite.

C.
Create an STS and submit as input to the SQL Performance Analyzer to get recommendations about
improving the performance of queries.

D.
Use the DBMS_ADVISOR.TUNE_MVIEW procedure to get recommendations about rewriting materialized
views.

E.
Use the DBMS_ADVISOR.QUICK_TUNE procedure to analyze queries based on the usage of query rewrite
with materialized views.



Leave a Reply 0

Your email address will not be published. Required fields are marked *