Your database supports an online transaction processing (OLTP) application. The application is undergoing some major sch
Posted: Sun Jun 11, 2023 3:51 pm
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.What should you use to achieve this?
A. Database replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer E. Automatic Workload Repository compare reports
A. Database replay
B. SQL Tuning Advisor
C. SQL Access Advisor
D. SQL Performance Analyzer E. Automatic Workload Repository compare reports