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…

The correct answer is D. SQL Performance Analyzer. You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of system change. Examples of common system changes include: •Database upgrades •Configuration changes to the operating system, hardware, or database •Database initialization parameter…

New Features for Performance

Question

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?

Options

ADatabase replay
BSQL Tuning Advisor
CSQL Access Advisor
DSQL Performance Analyzer
EAutomatic Workload Repository compare reports

How the community answered

(35 responses)

A
3% (1)
B
6% (2)
C
3% (1)
D
89% (31)

Explanation

You can use the SQL Performance Analyzer to analyze the SQL performance impact of any type of system change. Examples of common system changes include: •Database upgrades •Configuration changes to the operating system, hardware, or database •Database initialization parameter changes •Schema changes, such as adding new indexes or materialized views •Gathering optimizer statistics •SQL tuning actions, such as creating SQL profiles

Topics

#SQL Performance Analyzer#schema changes#workload performance#OLTP

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice