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.