SAP Knowledge Base Article - Preview

1957028 - Following upgrade of ASE, is it necessary to run UPDATE STATISTICS on RepServer system tables as with user tables? - SAP ASE

Symptom

  • User has upgraded ASE (from any version to any higher version)
  • It is considered a good practice to run UPDATE STATISTICS on user tables following upgrade
  • User has Replication Server installed, including the ASE RSSD database for replication system tables (those named rs_%)
  • Replication system tables are not considered ASE system tables
  • Is execution of UPDATE STATISTICS against RSSD replication system tables therefore necessary?

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) any version
  • SAP Replication Server (RS) any version

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

update stats, rep server, system table , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP , Sybase Replication Server (standalone) , 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.