SAP Knowledge Base Article - Preview

2658383 - Statistics / Histogram lost after running 'alter table' to modify a column - SAP ASE

Symptom

  • The table has an index on a varchar column.  Optdiag output displays statistics / histogram of the column after running 'update index statistics'. 
      
  • Run 'alter table' command to modify the varchar column to "increase" the length of the column (for example, from varchar(40) to varchar(60)).
       
  • After running 'alter table' command, optdiag output does not have statistics of the column.  The statistics of the column is gone.  
        
    No statistics for remaining columns:                                            "XXX"         (default values used) 

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) on ALL versions

Product

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

Keywords

alter table, optdiag, statistics, update index statistics, histogram, No statistics for remaining columns, default values used, column, modify, varchar , 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.