You have a SQL Server 2012 database named Database1. You execute the following code: You insert 3 million rows into Sales. You need to reduce the amount of time it takes to execute Proc1. What should

The correct answer is D. Run the following:. procedures-in-sqlserver/

Design and implement database solutions

Question

You have a SQL Server 2012 database named Database1. You execute the following code: You insert 3 million rows into Sales. You need to reduce the amount of time it takes to execute Proc1. What should you do?

Exhibit

Options

ARun the following:
BChange the WHERE clause to the following:
CRemove the ORDER BY clause from the stored procedure.
DRun the following:

How the community answered

(45 responses)

A
11% (5)
B
2% (1)
C
4% (2)
D
82% (37)

Explanation

procedures-in-sqlserver/

Topics

#query optimization#index creation#stored procedure performance#execution plan

Community Discussion

No community discussion yet for this question.

Full 70-459 Practice