Friday, October 21, 2011

HCC

Thanks to Tanel:

QUERY LOW - uses the LZO compression algorithm. Fastest.
QUERY HIGH - uses the ZLIB (gzip) compression algorithm.
ARCHIVE LOW - uses the ZLIB (gzip) compression algorithm, but at a higher compression level than QUERY HIGH.
ARCHIVE HIGH - uses Bzip2 compression. This is the highest level of compression available but is  most CPU-intensive.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...