Inlined LOBs are also qualified for compression. This page shows you how to compress the inlined LOBs. We will then run some performance tests and analysis against the regular LOB table, the inlined LOB table, and the compressed inlined LOB table. Select the actions on this page in order.
For more in depth analysis of data and index compression, refer to the Automated Compression and Compression Performance tutorials.
CREATE TABLE INLINE_COMPRESS
LIKE INLINELOBDATA COMPRESS YES
NOT LOGGED INITIALLY
INSERT INTO INLINE_COMPRESS
SELECT * FROM INLINELOBDATA
CALL ADMIN_CMD('REORG TABLE LOBDATA');
CALL ADMIN_CMD('RUNSTATS ON TABLE LOBDATA');
CALL ADMIN_CMD('REORG TABLE INLINELOBDATA');
CALL ADMIN_CMD('RUNSTATS ON TABLE INLINELOBDATA');
CALL ADMIN_CMD('REORG TABLE INLINE_COMPRESS');
CALL ADMIN_CMD('RUNSTATS ON TABLE INLINE_COMPRESS');
SELECT * FROM LOBDATA ORDER BY CUSTOMER_ID;
SELECT * FROM INLINELOBDATA ORDER BY CUSTOMER_ID;
SELECT * FROM INLINE_COMPRESS ORDER BY CUSTOMER_ID;
You can then graph the results for runtime, IO and CPU performance
If you hover your cursor over the bars in the graph you will see the exact sizes of each table.