Hi

Environment : Test
ASE version : 15.7/EBF 24641 SMP SP134 /P/X64/Windows Server/ase157sp133x/3925/64-bit/OPT

I am trying t use ASE compression (PAGE) to compress two tables, Tab_A and Tab_A_hdr, and the results are as follows:

TABLE SPACE :: (sp_spaceused)
State name rowtotal reserved (KB) data (KB) index-size (KB) unused (KB)
---------------- ------------ ------------ ---------------- ----------- ---------------- ---------------
Uncompressed Tab_A 62844937 61470952 55615668 653952 1199248
Compressed Tab_A 62844937 32262064 17395012 14865416 1292
Change Tab_A 0 29208888 38220656 -10211464 1197956

Uncompressed Tab_A_hdr 14040074 4346476 2516548 1709344 119484
Compressed Tab_A_hdr 14040074 3132380 823176 308652 472
Change Tab_A_hdr 0 1214096 1693372 -599308 119012

DATABASE SPACE :: (sp__dbspace)
Name Data MB Used MB Percent
Uncompressed 73728 69346 94
Compressed 73728 39636 54
Change 0 29710 40

Tab_A has has 4 x nonclustered indexes, 1 x Unique nonclusterd index
Tab_A_hdr has 4 x nonclustered indexes, 1 x Unique nonjclustered index

All the indexes (sp_spaceused <table_name>, 1) except the unique nonclustered index on Tab_A_hdr, which
has compressed marginally, have grown dramatically, post compression.

Has anyone here seen similar stats ??