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.
SAP Knowledge Base Article - Preview