One of your databases supports an OLTP workload. If a better plan is discovered for a statement, then you want that plan to be used. Which two can cause better plans to be used for a statement? (Choos

The correct answer is C. SQL Access Advisor E. adaptive execution plans. Explanation/Reference:

New Features for Performance

Question

One of your databases supports an OLTP workload. If a better plan is discovered for a statement, then you want that plan to be used. Which two can cause better plans to be used for a statement? (Choose two.)

Options

Aadaptive cursor sharing
Busing literals in SQL statements
CSQL Access Advisor
DSQL Performance Analyzer
Eadaptive execution plans

How the community answered

(33 responses)

A
3% (1)
B
15% (5)
C
76% (25)
D
6% (2)

Explanation

Explanation/Reference:

Topics

#adaptive cursor sharing#adaptive execution plans#SQL performance#plan optimization

Community Discussion

No community discussion yet for this question.

Full 1Z0-074 Practice