Tag: compression

Compressed LOB–my table got bigger?

We had an interesting question on AskTOM the other day about LOB compression. Someone was very concerned that after applying compression to the LOBS in the column of their table, the table actually got larger! Cue much confusion and panic, but after a little…

LOBs vs Data – when compression occurs

Just a quick tip for SECUREFILE lobs. You may be familiar with basic compression on data in tables. It is a dictionary attribute of the table, which is then taken into account when you perform: a SQL Loader direct load, or an INSERT with…

Licensed for Advanced Compression? Don’t forget the network

We often think of Advanced Compression being exclusively about compressing data “at rest”, ie, on some sort of storage device.  And don’t get me wrong, if we consider just that part of Advanced Compression, that still covers a myriad of opportunities that could yield…

Index compression–quick tip

If you’re appropriately licensed and want to use advanced index compression, you can take advantage of the setting a tablespace to automatically add compression as a default at a nominated level in the database.  From the docs: Here is an example of that in…

Index compression–working out the compression number

Richard Foote did a series of informative posts on Index Compression which concludes that there is whole lot of positives about index compression, and very little negatives.  But obviously one critical thing is choosing the right number of leading columns to compress. Is it…

Compressed partitions are not compressed tables

So…you have got a big table and you’re lucky enough to have a partitioning license. So far, so good. Then you read about using compression to make your older, static data faster and smaller and you thought … “Cool!” Let’s see that in action…