title: When to use Securefile LOB deduplication and compression?
body: <p>I have a table with BLOB column and SDO_GEOMETRY column (Spatial data). The BLOBs are stored as securefiles (Oracle 11g) I may be having quite a few repetitive columns of BLOB data. I am contemplating about adding compression or deduplication or both to save storage. I am wondering what is the difference between compression vs deduplication (compress is also going to save space by not storing duplicate data ?) When is it better to use them?</p>