SAP Knowledge Base Article - Preview

2351579 - No compression observed after running reorg rebuild following configuration of index compression

Symptom

  • ALTER TABLE SET INDEX COMPRESSION was run on a table with existing data
  • The index is relatively small
  • No change in space allocation is observed after running REORG REBUILD to apply compression
  • Space allocation does show compression if REORG REBUILD is run a second time


Read more...

Environment

 

SAP Adaptive Server Enterprise (ASE) 16.0 prior to SP02

Product

SAP Adaptive Server Enterprise 16.0

Keywords


index compression, REORG REBUILD, table compression, space allocation, database compression, small index, block size issue, upgrade ASE, REORG REBUILD, compression issue, database optimization , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.