下面的例子展示如何创建采用压缩的分区表。
The following example shows how to create partition table with compression.
企业版通过高级审计和透明数据加密功能为其增加了更高的安全性,还添加了拥有ColumnStore的数据仓库、压缩、以及分区。
The Enterprise edition adds more security through advanced auditing and transparent data encryption, and data warehousing with ColumnStore, compression, and partitioning.
压缩减少所存储数据的大小,从而在分区中生成未使用的空间。
Compress reduces the size of data being stored, thereby creating unused space in the partition.
DB 2提供了压缩一个表空间或分区中的数据的能力。
DB2 provides the capability to compress the data in a table space or partition.
注意,分区表的每个分区可以有不同的压缩词典,在DPF中一个表的每个分区也可以有不同的压缩词典。
Note that each partition of a partitioned table can have a different compression dictionaries and each partition of a table in DPF can have a different compression dictionaries.
数据中的模式:对于特定的表空间或分区,数据中重复出现的模式的出现频率将决定压缩的效果。
Patterns in the data: the frequency of recurring patterns in the data determines how effective compression will be for a particular table space or partition.
为了获得更好的性能和最小化空间消耗,我们建议使用数据库分区、范围分区、压缩和多维集群。
For best performance and minimal space consumption, we recommend using database partitioning, range partitioning, compression, and multi-dimensional clustering.
切分的好处(如分区一样)在于它可以压缩大型数据:单独的数据表在每个切分中相对较小,这样就可以支持更快速的读写速度,从而提高性能。
The benefit of sharding (like partitioning) is that it compacts big data: individual tables are smaller in each shard, which allows for faster reads and writes, which increases performance.
由于数据分散的原因,当Fours quare试图增加一个分区时没有成功,需要数据库离线才能对数据进行压缩。这也导致了系统宕机时间的延长。
The system outage was prolonged when an attempt to add a partition didn't work due to fragmentation, and required taking the database offline to compact it.
因此,压缩、重新打包、和收缩可能会像碎片整理程序一样,能够减少分区总的区段数量。
So compress, repack, and shrink might be able to reduce the total number of extents for a partition, just like the defragmenter.
你可以为表空间,表或者分区指定压缩属性。如果你为表空间指定了压缩属性,那么在该表空间下建的表会默认的继承压缩属性。
You can specify compression for a tablespace, a table, or a partition. If specified at the tablespace level, then all tables created in that tablespace are compressed by default.
一个分区表可以同时包含压缩的和非压缩的分区,并且可以给压缩分区指定不同的压缩方式。
A table can have both compressed and uncompressed partitions, and different partitions can use different compression methods.
显示或改变NTFS分区上文件的压缩。
COMPACT Displays or alters the compression of files on NTFS partitions.
警告:这会把你分区里所有文件替换成压缩文档里的文件!
WARNING: this will overwrite every single file on your partition with the one in the archive!
一次操作即可解压缩一个分区中所有压缩的NTFS文件,优化系统性能。
Decompress all compressed NTFS files on a drive in a single operation. Optimize system performance.
研究了压缩天然气加压站或加气站储气库储气容积分区的原理,指出分区的意义。
The principle on partition of storage volume in reservoir for compressed natural gas (CNG) pressure station or fueling station is studied, and the meaning of partition is pointed out.
研究了压缩天然气加压站或加气站储气库储气容积分区的原理,指出分区的意义。
The principle on partition of storage volume in reservoir for compressed natural gas (CNG) pressure station or fueling station is studied, and the meaning of partition is pointed out.
应用推荐