Your database supports a Decision Support System (DSS)workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the…

Your database supports a Decision Support System (DSS)workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?