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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.