compression – Learning is not a spectator sport

Compression default settings

If you are loading a data warehouse or similar environment where your default approach would probably be to compress all

There has always been a bit of a Catch-22 with some of the really cool options in the Oracle Database.

We had an interesting question on AskTOM the other day about LOB compression. Someone was very concerned that after applying

Just a quick tip for SECUREFILE lobs. You may be familiar with basic compression on data in tables. It is

We often think of Advanced Compression being exclusively about compressing data “at rest”, ie, on some sort of storage device.

If you’re appropriately licensed and want to use advanced index compression, you can take advantage of the setting a tablespace

Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives

So…you have got a big table and you’re lucky enough to have a partitioning license. So far, so good. Then