The sp_iqsetcompression stored procedure controls the compression of columns of data type LONG BINARY and LONG VARCHAR when writing database buffers to disk. You can also use sp_iqsetcompression to disable compression. This functionality saves CPU cycles, because certain data formats stored in a LONG BINARY or LONG VARCHAR column (for example, JPG files) are already compressed and gain nothing from additional compression. The sp_iqshowcompression stored procedure displays the compression setting of large object columns.
