SAP Knowledge Base Article - Preview

1970646 - Query performance is unstable.

Symptom

The performance of a query is unstable. Sometimes the response is fast, but sometimes it is slow. When analyzing the execution plan, SQL Server optimizer prefers to use a cluster index seek (table scan) even though there is a secondary index (non-clustered) whose columns fits the query perfectly.


Read more...

Environment

SAP systems based on Microsoft SQL Server.

Keywords

Performance issue, Slow, undistributed, different, High I/O cost, SWWWIHEAD, CV04N , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.