SAP Knowledge Base Article - Preview

2351178 - SYB: Reorg rebuild command on index can't compress the existing index data.

Symptom

  • Reorg rebuild on index command can't compress existing index data.

    [original index size]
                                 WBCROSSGT_var~0 WBCROSSGT_var~NAM  
     WBCROSSGT_var            4834              1050

    alter index WBCROSSGT_var."WBCROSSGT_var~0" set index_compression=page
    alter index WBCROSSGT_var."WBCROSSGT_var~NAM" set index_compression=page

    reorg rebuild WBCROSSGT_var "WBCROSSGT_var~0"
    reorg rebuild WBCROSSGT_var "WBCROSSGT_var~NAM"

    [index size after enabling index compression]
    select substring('WBCROSSGT_var',1,15),
    data_pages(4,object_id('WBCROSSGT_var'),2) as "WBCROSSGT_var~0",
    data_pages(4,object_id('WBCROSSGT_var'),3) as "WBCROSSGT_var~NAM"
    go
                                 WBCROSSGT_var~0 WBCROSSGT_var~NAM 
     WBCROSSGT_var            4834              1050


Read more...

Environment

  • ASE Version: ASE16.0 and later
  • Compression

Product

SAP Adaptive Server Enterprise 16.0

Keywords

  • CR 801788, 801788, CR#801788, index compression
, KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.