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
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.