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 ONE Support launchpad (Login required).

Search for additional results

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