At the client I am currently at, they went a little overboard in compressing all tables. Slowly removing compression where it doesn't make sense. Hoping someone can share some light on what I'm seeing. We have a table with 22 rows with Maxrows set to 1 (to get 1 row per page). Compressed the tablespace has 130 pages, uncompressed it is 25 pages. I can understand the 25 pages when uncompressed (22 for data, 1 space map page, 1 header page and 1 freepage --> freepage is set to 15). Wondering why so many pages (130) when it is compressed? I thought the dictionary is to 64KB (16 pages), expect total pages to be 41 not 130.
The table has 2 columns: char(8) & dec(10) with 22 rows. Tablespase has Segsize 64, Freepage 15, Pctfree 10, Maxrows 1, pagesize is 4K. Rows are never inserted nor deleted, only updated.