Re: [Info-Ingres] Clob table compression

On Oct 2, 2008, at 8:01 AM, Laframboise, André wrote:
>
>
> Does anyone know if data compression on a LOB table also compresses
> the iietab table ?
>

It appears that data compression is NOT applied to extension tables
under any circumstances. This kinda-sorta makes sense, given that
the current data compression only deals with trailing blanks. The
assumption would be that only the last LOB segment is likely to be
compressible, and unless LOB's are generally short, that is not a
significant percentage of the whole.

With a better compression method it might make more sense to allow
etab compression too.

Karl