What should you use to achieve this?

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?

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.
SQL Tuning Advisor

B.
Automatic Workload Repository compare reports

C.
SQL Performance Analyzer

D.
Database replay

E.
SQL Access Advisor



Leave a Reply 1

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