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 theDBMS_MVIEW.EXPLAIN_REWRITEprocedure 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 performanceof queries.
D.
Use theDBMS_ADVISOR.TUNE_MVIEWprocedureto get recommendations about
rewritingmaterialized views.
E.
Use theDBMS_ADVISOR.QUICK_TUNEprocedure to analyze queries based on the
usage of query rewrite with materialized views.
imo
B – right
E – wrong
A,B,C
Don’t you think that D is correct and C not?
D is more for MV and C for all kind of queries, not only related to MV and query rewrite
B & D are both wrong by definition! Rewrite is happening but not beneficial so we need to assess the actual usage of MV in the first place, considering SQL Performance Analyzer(C), SQL Access Advisor (A) and SQL Tuning Advicor(E)!
A,B,E