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.
SELECT *
FROM customer_address_without_compression
ORDER BY customer_id;
SELECT *
FROM customer_address_with_compression
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 precise results for each table.