The "with hashing" option to update statistics can generate invalid or useless statistics.
Example (part of output from optidiag on a table that has a large number of unique values):
Step Weight Value
1 0.01127901 <= "0�����"
2 0.98871720 < "99998"
3 0.00000198 = "99998"
4 0.00000000 < "99999"
5 0.00000182 = "99999"
The result is useless as almost all values have been grouped into a single cell.
- SAP Adaptive Server Enterprise (ASE)
- SAP Adaptive Server Enterprise Cluster Edition (ASE CE)
- update statistics with hashing
Sybase, ASEServer, SAPASE, dataserver, update statistics, hashing, optdiag, histogram , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed
About this pageThis 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.