SAP Knowledge Base Article - Preview

2662968 - Column histogram steps does not match to partition histogram steps for a hash partition table - SAP ASE

Symptom

  • Update statistics command with histogram_tuning_factor does not have impact on the global (column) histogram which cause the global histogram steps does not match to the partition histogram steps.
  • Query may use different query plan when objects has large number of partitions and skew data in cenrtain partitions.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 16.0

Keywords

update statistics, histogram_tuning_factor, Actual step count, CR 815641 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.