Run the SQL in the Ad Hoc command window to the right.

Create the base table

It creates the CUSTOMER_ADDRESS_WITHOUT_COMPRESSION table that you will use as a baseline to demonstrate how well compression performs.

Populate the table with data

It inserts approximately 100,000 rows of data into the CUSTOMER_ADDRESS_WITHOUT_COMPRESSION table.

Update statistics

To ensure that the optimizer is working at full pontential, update the table statistics.