So why are times often better for compressed tables? This step performs a deeper analysis of both CPU and IO performance.

Select the actions on this page in order.

Run performance tests

The first step runs a select with an 'order by' clause against a compressed and uncompressed table.

SELECT * 
   FROM customer_address_without_compression 
   ORDER BY customer_id;

SELECT * 
   FROM customer_address_with_compression 
   ORDER BY customer_id;

Graph the results

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 precise results for each table.