You are developing a database application by using Microsoft SQL Server 2012. You have a
query that runs slower than expected.
You need to capture execution plans that will include detailed information on missing
indexes recommended by the query optimizer.
What should you do?
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
A.
Add a HASH hint to the query.
B.
Add a LOOP hint to the query.
C.
Add a FORCESEEK hint to the query.
D.
Add an INCLUDE clause to the index.
E.
Add a FORCESCAN hint to the Attach query.
F.
Add a columnstore index to cover the query.
G.
Enable the optimize for ad hoc workloads option.
H.
Cover the unique clustered index with a columnstore index.
I.
Include a SET FORCEPLAN ON statement before you run the query.
J.
Include a SET STATISTICS PROFILE ON statement before you run the query.
K.
Include a SET STATISTICS SHOWPLAN_XML ON statement before you run the query.
L.
Include a SET TRANSACTION ISOLATION LEVEL REPEATABLE READ statement
before you run the query.
M.
Include a SET TRANSACTION ISOLATION LEVEL SNAPSHOT statement before you
run the query.
N.
Include a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement before you
run the query.
Correct answer is K
0
0
Answer is K
0
0
Show answer button doesn’t work
0
0
Agree with all. K.
0
0
K is correct.
https://msdn.microsoft.com/en-us/library/ms187757.aspx
[…] When SET SHOWPLAN_XML is ON, SQL Server returns execution plan information for each statement without executing it, and Transact-SQL statements are not executed. After this option is set ON, execution plan information about all subsequent Transact-SQL statements is returned until the option is set OFF. […]
0
0
K
0
0