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