SAP Knowledge Base Article - Preview

2721474 - Multi-Column Auto-Created column statistic(_WA_Sys... Statistics) are found in some systems

Symptom

Auto-created column statistics should be named as _WA_Sys_<hex value of column>_<hex value of table> as of SQL Server 2005.

The '<hex value of column>' mentioned above should be numbers, for example,  _WA_Sys_00000012_72FC4130.

And statistics proporties should look like this:

All density   Average Length    Columns
=======  ========       ===============
0.5                 2.0                   DELFLAG

 

But column statistics whose name format are  _WA_Sys_<name of column>_<hex value of table> exist in some systems.

The <name of column> consists of letters, for example, _WA_Sys_FUNCT_5FKK728B.

Besides, these statistics contain multiple columns, statistics proporties look like this:

All density     Average Length     Columns
=======   ===========  ===================================
0.14285715        3.0                     FUNCT
3.1025069E-5   16.999193        FUNCT, BEG
3.1024105E-5   19.999193        FUNCT, BEG, CON_NAME


Read more...

Environment

Netweaver-based SAP products running on Microsoft SQL Server

Product

SAP Supply Chain Management 7.0

Keywords

_WA_Sys, SQL Server 2000, multi-column statistics, column statistics, DATA_LENGTH_0 , 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.