Note: This question is part of a series of questions that present the same scenario. Each question in this series
contains a unique solution. Determine whether the solution meets the stated goals.
You are developing a new application that uses a stored procedure. The stored procedure inserts thousands of
records as a single batch into the Employees table.
Users report that the application response time has worsened since the stored procedure was updated. You
examine disk-related performance counters for the Microsoft SQL Server instance and observe several high
values that include a disk performance issue. You examine wait statistics and observe an unusually high
WRITELOG value.
You need to improve the application response time.
Solution: You add a unique clustered index to the Employees table.
Does the solution meet the goal?
A.
Yes
B.
No
Explanation:
https://msdn.microsoft.com/en-us/library/ms190457.aspx
I do not see how adding clustered index can improve inserts. Inserts to non-indexed heap is fastest.
19
2
Yes, INSERT performance can be improved by adding of clustered index only when non-clustered indexes exist for this table.
0
13