SAP Knowledge Base Article - Preview

1925271 - Why doesn't the 'select datachange()' value get set back to 0 (zero) after running 'update statistics <tablename>' in ASE ?

Symptom

  • There was no change seen in the datachange function result after executing the following:
    1. updating a column on a table
    2. select datachange ("tablename",null,null)
    3. running update statistics 
    4. select datachange ("tablename",null,null) 
  • Why doesn't the 'select datachange()' value get modified after running 'update statistics'

  • The expectation was that the results of 'select datachange ("tablename",null,null)' immediately after executing 'update statistics' would be 0.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Sybase Adaptive Server Enterprise (ASE) 15.0
  • Sybase Adaptive Server Enterprise (ASE) 15.5

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5

Keywords

KBA , histogram , histogram steps , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.