Character compression


As you know. When insert ‘oat’  into char(10) ,database will add space for 7 character as ‘oat       ‘ (Proof by SELECT CAST(‘OAT’ AS CHAR(10)) ). What happen when compress ‘oat’ & compress ‘oat       ‘ on character(10)? We can compress ‘oat’ instead ‘oat       ‘ because table have limit header space for store compress command.

The result show on table.

Test Compress with decimal and char

Test Compress with decimal and char

ติดป้ายกำกับ:

ใส่ความเห็น

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / เปลี่ยนแปลง )

Twitter picture

You are commenting using your Twitter account. Log Out / เปลี่ยนแปลง )

Facebook photo

You are commenting using your Facebook account. Log Out / เปลี่ยนแปลง )

Google+ photo

You are commenting using your Google+ account. Log Out / เปลี่ยนแปลง )

Connecting to %s

%d bloggers like this: