SAP Knowledge Base Article - Preview

2618076 - Add Out of range histogram adjustment for lower bound values - SAP ASE

Symptom


Add Out of range histogram adjustment for lower bound values.

"Out of range histogram adjustment" message is shown for upper bounds as well as an accurate selectivity value:

Estimating selectivity of index 'tempdb..tn.idx', indid 2

i = 5

Estimated selectivity for i,

Out of range histogram adjustment, <<<<<<<<<<<<<<

selectivity = 2.261881e-06,

scan selectivity 2.261886e-06, filter selectivity 2.261886e-06

1 rows, 1 pages

Data Row Cluster Ratio 1

However there is no message for lower bounds  and selectivity value is zero:

Beginning selection of qualifying indexes for table 'tempdb..tn',

Estimating selectivity of index 'tempdb..tn.idx', indid 2

i = -442109

Estimated selectivity for i,

selectivity = 0,

scan selectivity 2.261886e-06, filter selectivity 2.261886e-06

1 rows, 1 pages


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR814024 , 814024, optimizer, costing, Out of range histogram adjustment , lower bounds. , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.