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=pagereorg 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
Keywords
- CR 801788, 801788, CR#801788, index compression
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.