Developing SQL Databases — Question 170

Note: This question is part of a series of questions that present the same scenario. Each question in the 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?

Answer options

Correct answer: A

Explanation

Creating a unique clustered index on the Employees table can improve the application's response time by optimizing data retrieval and reducing fragmentation. This action helps in efficiently managing disk I/O operations, which is crucial given the high WRITELOG value indicating potential bottlenecks. The alternative answer, 'No,' would not recognize the benefits of indexing in addressing the application's performance issues.