Compression using value compression row format.
使用值压缩行格式的压缩。
In addition, the row format of value compression has a two-byte overhead per row.
此外,值压缩的行格式会为每一行占用两个字节。
It therefore depends on the table structure as to whether the row format of value compression has positive results.
因此,值压缩的行格式是否能产生正面的效果,取决于表的结构。
In most cases, ALTER SET DATA TYPE requires table reorganization (reorg) because it changes the physical row format.
大多数情况下,ALTERSETDATATYPE需要对表执行重组(reorg),因为它修改了物理行格式。
The statement returns the number of bytes for each table entry that are saved by using the value compression row format.
该语句返回使用值压缩行格式为每个表条目节省的字节数。
By changing the table attribute VALUE COMPRESSION, you can determine in what row format new rows for a table are stored.
通过更改表属性VALUECOMPRESSION,可以决定按照什么行格式存储新的表行。
But as you can see for the DEPARTMENT table, value compression can be beneficial, even if the alternate row format of value compression causes some overhead.
然而,正如您所看到的,对于DEPARTMENT表,虽然值压缩行格式会导致一些开销,但是值压缩的确是有益的。
But as you can see for the DEPARTMENT table, value compression can be beneficial, even if the alternate row format of value compression causes some overhead.
然而,正如您所看到的,对于DEPARTMENT表,虽然值压缩行格式会导致一些开销,但是值压缩的确是有益的。
应用推荐