Data Compression Applicability

Hi,

Can you tell me whether the compression intended for Katmai is suitable for OLTP applications?

I know that Oracle has had compression for a number of years, but it is not particularly useful for tables subject to a reasonable degree of inserts/updates. It would be great if Katmai compression could be used across the board with substantial space savings for every application type. What's the story ?

Many Thanks,

Derek

The main focus for this release is data warehouse scenarios, but we have a compression scheme that might be useful for OLTP applications as well.

We will be supporting compressing for both bulk load and normal DML operations.

More information will come when compression becomes part of a future CTP.

Thanks,